@nankw83
i see, so if Excel is not copying but assigning, why is the CutCopyMode = False line afterwards required? So for every set of assigning to do, i still need to add this Application CutCopyMode = False immediately afterwards ?
2. Mainly, i need to double check to ask about this line, a third copied range starts at A5 in the source sheet:
if i add a third copy range in another sheet where the copied range starts at GY5, must the variable 'a' still, and always start at column A? :
as long as Lr always refers to the last column number.
Did i understand correctly?
3. My last question is, what is the (3) inside the End command, is that a non-negotiable constant ?
Stewart
Bookmarks