Need Help - Copy/Paste & Header Row

  • Thread starter Thread starter Donnie Stone
  • Start date Start date
D

Donnie Stone

I have a header in row 1. Is it possible to modify the code so it excludes
it and starts executing in cell A2 for example?
 
Donnie,

For Each cell In Intersect(ActiveSheet.UsedRange.Columns(1),
Range("2:65536"))

HTH,
Bernie
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Exclude header row when copying autofilter results? (XL2003) 1
Adjust code to run anywhere on sheet 3
Newbie help needed please... 13
Post my named ranges in column A 10
Select 'used range' except header row in excel 2007 3
Copy formula down variable rows based on (lastrow) from another sh 3
Sorting columns horizontally 2

Back
Top