Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COPY AND PASTE
I'm using GO TO /Current Region to create a macro to select a block of data
to copy and paste into a new worksheet. However, I dont want to copy the header line...anyone??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COPY AND PASTE
Something like this will solve your problem. You need to resize your range to
exclude the first row: Set Workrange = Workrange.Offset(1, 0).Resize(Workrange.Rows.Count - 1) -- Regards, Fred "Polarbilly" wrote in message ... I'm using GO TO /Current Region to create a macro to select a block of data to copy and paste into a new worksheet. However, I dont want to copy the header line...anyone??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
COPY AND PASTE
Assuming the headers occupy only one row. If more than 1 row is a header,
change the two 1's in the line beginning with ".Offset(1,0)....." to whatever you need. Sub test() With Sheets("Sheet1").Range("A1").CurrentRegion .Offset(1, 0).Resize(.Rows.Count - 1, _ .Columns.Count).Copy _ Destination:=Sheets("Sheet2").Range("A1") End With End Sub "Polarbilly" wrote: I'm using GO TO /Current Region to create a macro to select a block of data to copy and paste into a new worksheet. However, I dont want to copy the header line...anyone??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't Copy and Paste or Paste Special between Excel Workbooks | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) | |||
I cannot paste from one workbook to another. Copy works, paste do. | Excel Discussion (Misc queries) | |||
Copy/paste/paste special is not available | Excel Discussion (Misc queries) |