jackass209
New Member
- Joined
- Jul 14, 2007
- Messages
- 49
Trying to copy columns 6 til the last non-blank column and paste it 1 column to the right. This is what I'm trying:
sh3.Columns(6 & ":" & LaatstKol).Copy
sh3.Columns(7 & ":" & LaatstKol + 1).Select
ActiveSheet.Paste
Can someone tell me what I'm doing wrong? Feeling pretty stupid over here...
sh3.Columns(6 & ":" & LaatstKol).Copy
sh3.Columns(7 & ":" & LaatstKol + 1).Select
ActiveSheet.Paste
Can someone tell me what I'm doing wrong? Feeling pretty stupid over here...