I have two named ranges of equal number of cells and same position on Sheet: Sheet4 OrigName and Sheet1 NewName.
Want OrigName to populate with values from NewName.
Getting "Compile error: Method or data member not found" on highlight below
Copy values of one range to another range on a different worksheet
-
acat -
January 29, 2019 at 10:53 PM -
Thread is marked as Resolved.
-
-
-
-
Hi Mario,
You are probably close with the solution. I had to switch OrigName & NewName around, as I need OrigName range to populate with values from NewName. And it did populate, but with "#NAME?". The entire named range from A6:A1000 populated with it, where as NewName range has data from A6:A69 and it is similar to "12345 987654321" or "abcde 987654321"
I tried code below, but last line comes up red and gives "Compile error: Syntax error"
Replacing () with [] in those two lines gives "Run-time error'424': Object required" on line in red below -
-
Hello
Why have you entered the name of the Sheets?
If you have defined Names just type them in square brackets.
In my macro there are no names of the sheets and it worked.bye,
Mario -
-
Because your code resulted in populating with "#NAME?", per my answer above in #3. I posted the code in #4 which does exactly what is needed. I further modified that and currently running code below:
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!