In a Macro trying to select a Range of rows & columns using variab

T

TeddyBear

In Excel I have written a macro that scrolls down the rows of a spreadsheet.
I hole the starting row in a variable vStartVendrow and when I identify a
change in one of the columns I store the last row in variable vEndVendrow. I
would like to achieve the same thing as the following statement would

Range("A9:N10").Select

I know the columns to select e.g. A thru to N but my rows are in variables.
Hence I would like to achieve the following:

Range("AvStartVendrow9:NvEndVendrow").Select

I know the statement above does not work How can I achieve what I am trying
to do.
 
O

Og

You are more likely to received informed responses to your Excel programming
queries if you post where the Excel programming gurus hang out:
microsoft.public.excel.programming
Steve
 
T

TeddyBear

Hi Og,

Found my answer where you recommended. Thx...

The answer by the way is as follows:

Range(vStartVendrow & ":" & vLast Vendrow).Select

There as a question and answer at the excel.programming site which was
similiar to my question...
 
O

Og

Thank you for the follow-up.
Steve

TeddyBear said:
Hi Og,

Found my answer where you recommended. Thx...

The answer by the way is as follows:

Range(vStartVendrow & ":" & vLast Vendrow).Select

There as a question and answer at the excel.programming site which was
similiar to my question...
Click to expand...
 
Top