Selecting

[machinist]

Basically i want to have something select an area i have done it before but i'll put the example

sub check
'find the cell to check
activecell.offset(1, 2).activate
'the bit below is where i'm stuck
range(r-10, c-1:r-0, c-0).select

i don't know what i am doing wrong could someone help plz

[TheRobster]

Does the range you want to select change at all (e.g. as you enter data into the worksheet the range changes location/size) or does the range always have the same cell reference(s)?

[RobDog888]

Could it be your syntax in this line?

range(r-10, c-1:r-0, c-0).select
'Should be...
Range("A1:B10").Select