Macro - use variable integer as text
Dear Colleagues,
can somebody help me to find a solution how to use a varible integer in a
macro as a part of text string?
I have in my macro a varible X which contains a figure representing the
number of rows in a spreadsheet. This amount is different in differnt
workbooks. For example now it is X = 50.
Now I need to incorporate this variable to a range declaration. For
example:
Range("D2:D50").select
Here I need to have the figure 50 to be replaced by the variable X.
Thanks a lot for your help.
Drahos.
|