Accessing ranges with integer variables
Hello,
I need a snippet of code to implement the code show here, but
using variables as the range argument.
Worksheets("graphs").Range("A1:B200").ClearContent s
What I would like to do is replace "A1:B200" with an integer value (to
be entered by user) of 200. Is there a way I can do this using
Cells(x,y)? Can the Cells command be used to access a range, as
opposed to a single cell?
thanks
Andy
|