How can I sort out this Worksheet Object?

Asked Jun 24 '17 at 06:44

Active Jun 24 '17 at 07:00

Viewed 31 times

So I have been searching around and I am having trouble doing it, even if I tried many times but compilation failed. So, what I want to do is this (in a pretty simple and wrong form):

Worksheets("Sheets1").Range("A1") = Worksheets("Sheets2").Cells(3,Cells(3,8))

The Cells(3,Cells(3,8)) is in the same Sheet.

edited Jul 09 '18 at 18:41

Community

asked Jun 24 '17 at 06:44

StavrosWTF

Same sheet as in? Also are you sure it is `Sheets1, Sheets2` and not `Sheet1` or `Sheet2` – Siddharth Rout Jun 24 '17 at 06:53
I mean that Cells(3,8) is in Sheets2. Oh and i put those Worksheet names as an example, not using those of course. – StavrosWTF Jun 24 '17 at 06:58
1

Then it should be `Worksheets("Sheets2").Cells(3,Worksheets("Sheets2").Cells(3,8))` – Siddharth Rout Jun 24 '17 at 06:58
https://stackoverflow.com/questions/36368220/is-the-in-range-necessary-when-defined-by-cells – Siddharth Rout Jun 24 '17 at 07:01
Thanks man. Appreciate it. – StavrosWTF Jun 24 '17 at 07:15

How can I sort out this Worksheet Object?

0 Answers0