CurrentRegion Selecting

[He4Giv]

Hello.
I have header info in cells A4 (Quantity), B4 (Dwg. No),
C4 (Drawing Description), and D4 (Dated).
we fill in the appropiate info under these headers
starting in A5 and movig to the right.
When I wrote the code to select CurrentRegion and copy and
paste just the data to a log sheet it also grabbed the
Header info. Keep in mind that the data rows will vary, we
may have 2 rows filled in or 6 under the Header.

How do I tell VBA NOT to grab the header info, and to just
grab the data info even though the header may be part of
the CurrentRegion?

Thank you
[email protected]

 

[Grey Newt]

Try this... ('Lump' is of course a variable of your choice - not an Excel keyword !!)

Set Lump = ActiveCell.CurrentRegion
Lump.Offset(1, 0).Resize(Lump.Rows.Count - 1, Lump.Columns.Count).Select