Passing Arguments in Excell
If you don't use the quotes, you can use variables. A mix is also possible.
Let's say VarA' value is "A" and VarB's value is "B2"
Then you could use Range(VarA & "2:" & VarB) to mean Range("A2:B2")
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"ub" wrote in message ...
| Hi,
| Is there a way , I can pass arguments in Excell worksheet object ' Range'
| when writing VBA code.
| Ex: worksheet.range("a1:c1")
| Can I pass arguments to the range object for the cell reference ( a1 & c1).
| Thanks
|