Without seeing your code, perhaps this is the reason... Most formulas to select the first available row to make entries in are of the form (last row of the worksheet).End(xlUp).Offset(1, 0).Originally Posted by thekneeguy
Because of the Offset(1, 0) the second row on the worksheet is chosen. So the 1st row is conventionally reserved for headings and this requires a workaround when there are no headings.
HTH,
John
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Posting Permissions
Reply With Quote