Thread
:
Excel Prob
View Single Post
#
4
Posted to microsoft.public.excel.programming
Chip[_3_]
external usenet poster
Posts: 133
Excel Prob
Use this:
Rows("2:2").Select
Selection.Cut
Sheets(importwks).Select
Range(targetrow).Select
ActiveSheet.Paste
Also, to find the last row, I would suggest this code
targetrow=Sheets(importwks).UsedRange.Rows.Count
Reply With Quote
Chip[_3_]
View Public Profile
Find all posts by Chip[_3_]