I have a macro in a spreadsheet I took over from a colleague that stops in a 'weird' place - and I can't figure out why. Hope someone here can help
The macro stops in the second line.Please Login or Register to view this content.
I have a macro in a spreadsheet I took over from a colleague that stops in a 'weird' place - and I can't figure out why. Hope someone here can help
The macro stops in the second line.Please Login or Register to view this content.
You're copying two different cells (A6,AO2000) and trying to paste into one (A6). Are you trying to paste the full range? If so, that would be Range("A6:AO2000")
@jomili,
Range("A6", "AO2000") refers to the range from A6 to AO2000 and not to just those two cells-that would be Range("A6,AO2000")
@DKAbi,
what error occurs?
Josie
if at first you don't succeed try doing it the way your wife told you to
Thanks. I just corrected the macro, but still after the change I get a debug error.
I'm located in Denmark, so I think there's a difference of where to use ; and ,? I want to copy paste the entire range.Please Login or Register to view this content.
I tried to re-record my macro manually, but got a strange error message when I tried to copy paste as values into the same range. I have attached the error message and wonder if anyone can tell me how to correct for future runs...
as far as i understood you want to make values from formula results in those cells, how about:
RegardsPlease Login or Register to view this content.
Please use [CODE]-TAGS
When your problem is solved mark the thread SOLVED
If an answer has helped you please click to give reputation
Read the FORUM RULES
Wow, tehneXus. That did the trick. Many thanks for your quick reply and help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks