Worksheets("Sheet1").Range("BC" & Row & ":EV" & Row).Copy _
Destination:=Worksheets("Sheet2").Range("B" & Row)
ActiveCell.Offset(1, 0).Select
it is taking the values from Column B I want it from BC
Please help
Asked
Active
Viewed 138 times
0
Tim Williams
- 154,628
- 8
- 97
- 125
SID
- 99
- 9
-
There is an "AA1" Cell – SID Jun 12 '19 at 05:56
-
What's the value in `Row` when it fails? If it's just a number there's nothing in your posted code which would cause values to be copied from ColB – Tim Williams Jun 12 '19 at 06:03
-
value is 16. Thats what is happening tim:( – SID Jun 12 '19 at 06:08
-
[How to avoid using Select in Excel VBA](https://stackoverflow.com/questions/10714251/how-to-avoid-using-select-in-excel-vba) – Tim Stack Jun 12 '19 at 06:09
-
Then there's something else not shown in your question which is responsible for that. – Tim Williams Jun 12 '19 at 06:09
-
Try specifying a workbook too for the two ranges. It may be that the active workbook the code is referring to now does not have the values you are expecting – Tim Stack Jun 12 '19 at 06:10
-
Did No luck. Please help – SID Jun 12 '19 at 06:17
-
BC16:EV16. This is what is the range – SID Jun 12 '19 at 06:22
-
We can't help you without you showing us the full code. As @TimWilliams mentioned, something else in your code is causing the problem – Tim Stack Jun 12 '19 at 06:28