Posted by Sam on July 26, 2001 9:23 AM
I'm having trouble with a certain macro that uses the range command. What I need done is to copy a cell in sheet 2 and paste it in the same column x rows down. The x is the same number of rows as sheet 1 uses. Here is my current code if anyone could give suggestion on how to improve this code or has a better code all together that would help out a lot.
Dim EndRow As Integer
EndRow = Selection.End(xlDown).Count
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _