I created a macro using the recording function. I don't know VBA, so I'm not real sure how to resolve some of the issues. In this macro, I was trying to copy a range of 7 columns (92 rows) of data, of which only 5 columns contain data, and paste them into another worksheet. Depending on the data set, there could be data in 5, 6 or 7 columns. When I re-ran the macro with 7 columns of data, only 5 of the columns are getting pasted. I initially recorded the macro with no data, and no matter if I have 5, 6 or 7 columns of data, I only get 5 of the columns in my receiving worksheet. What should I look for in the code to fix this so that no matter what I paste in 7 columes?
Here's the code:
Thanks!
Bookmarks