Reference an Entire Row using Variable Names in Range Function

[whittbullard]

Hi - this is simple but I am new to VBA so the syntax really messes me up.

I want to select an entire row but use a variable as I will be referencing this row later. I wasn't sure if I needed to use Long or Int and how to reference the variable. It seems like every time I try to reference variables in a range and use a colon I get an error.

PS I know I shouldn't use select. Thanks in advance

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[Andy Pope]

Use Long so it can handle the larger row numbers

Please Login or Register  to view this content.

[whittbullard]

Very Helpful. Thank You.

Now if I want to select A22 to D22 where LastCol is a long of 2 from a find method I try to write this:

Please Login or Register  to view this content.

Do I need to use Cells nested in my range?

Please Login or Register  to view this content.

I figured it out

Please Login or Register  to view this content.

[Andy Pope]

As you have row and column information as numbers use

Please Login or Register  to view this content.