How to Select Column Range Starting at Row 2

[krayon]

Hi, I have the following code. It works great, however, if I insert a row so that my table starts on row 2 instead of row 1, I get an error. How do I make it work with my table starting on row 2?

Please Login or Register  to view this content.

Thanks!

[AlphaFrog]

If the table starts at row 2 and it has a Header row then the actual data starts at row 3.

For i = 3 To lr

[krayon]

If the table starts at row 2 and it has a Header row then the actual data starts at row 3.

For i = 3 To lr

Thank you! I knew it was something simple.

[AlphaFrog]

You're welcome. Thanks for the feedback.