Using variable in Range in Sub

**Orada** · 03-03-2011, 12:45 PM

Hi

I seem to be confusing the use of variables in ranges somehow so would appreciate help. The code below is intended to highlight one row as defined by the variable r which is a for next counter, but instead it highlights the whole sheet.

Please Login or Register  to view this content.

The routines below to clear certain columns and remove all formatting before running work fine but these variables are not part of a loop counter.

Please Login or Register  to view this content.

Some insight from the more experienced as to what I am doing wrong would be greatly appreciated.

**stnkynts** · 03-03-2011, 12:52 PM

Instead of

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Instead of

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

**StephenR** · 03-03-2011, 12:52 PM

Your first bit of code should select A1:S1 (or whatever r equals) - are you saying it doesn't? Apart from unnecessary use of Select your use of variables looks fine to me.

**Orada** · 03-03-2011, 02:05 PM

Originally Posted by stnkynts

Try:

Please Login or Register  to view this content.

Try:

Please Login or Register  to view this content.

Thanks but got runtime error - Method chance of object global failed.

**stnkynts** · 03-03-2011, 02:12 PM

Could you submit your whole code or a copy of the workbook for review?

**Orada** · 03-03-2011, 02:15 PM

Originally Posted by StephenR

Your first bit of code should select A1:S1 (or whatever r equals) - are you saying it doesn't? Apart from unnecessary use of Select your use of variables looks fine to me.

OK, I'm losing the variable, when r is null then the complete worksheet gets selected for format.

I'll get it sorted now, thanks, I had been calling the routine from a workbook