Hello, I am trying to increment the column number within a nested for loop, so I don't have to copy this code for each column. Any ideas?
For r = 1 to row.count
sheets(1)
range ("A" & r).select
Selection.copy
sheets(2).select
range ("A" & r).select
selection.pastespecial
Next r
Thank you for the help!
Bookmarks