Range(Range("B19"),Cells(26, MyVal))


"John Wilson" wrote in message
...
A quickie....

This is what I have...

Range("B19:J26").Select

I have a variable "MyVal" = 10

I need to modify the formula to substitute the 10 in
place of the "J"

Thanks,
John