Going to a "set" range
On May 14, 10:25*am, wrote:
On May 14, 10:06*am, "Patrick Molloy"
wrote:
you can't activate a range that's not on the active sheet. you probably
don't need to either.
to populate a cell with data
worksheet("x").Range("A1") = worksheets("b").Range("C2").value
or, with your code, something like this
rng.value = worksheets("v#2").Range("V__2").Value
wrote in message
...
‘User clicks a button in UserForm5 (UF5) to choose a vehicle to edit.
|