Thread: copying data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
GailK GailK is offline
external usenet poster
 
Posts: 6
Default copying data

Hi,

I'd like to copy the range in 'calc worksheet' into 'DailyTeleStat'
worksheet following the last entry. I have seen vba coding where data can
be copied into the first empty row, however, the row being copied into is not
complete empty .. contains date/week number/period etc in the first few
columns (b-e); therefore, I'd been looking to have the data copied starting
at column f. How can I update the coding below to accomplish my means?


Sheets("calc worksheet").Select
Range("C95:J95").Select
Application.CutCopyMode = False
Selection.Copy
Sheets("dailyTeleStat").Select
Range("F461").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

Thanks,
Gail