I am trying to copy a number of columns of data from one worksheet to another. I turned the data from row 2 down in each column into a named range using the following code:
This seems to have done the job; i.e. I can "goto" the named ranges using the dropdown menu manually. However, when I try to use vba to copy and paste the data in these ranges to another sheet, I don't get any error message, but nothing happens at all. I also tried to just create a "goto" macro to see if I could get excel to select the range based on my command, but I can't get that to work either. What am I doing wrong? Thanks much in advance for your help!!!
Bookmarks