| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
| "Subscript out of range" error for: Workbooks("Test1.xls").Save | Excel Programming | |||
| Using "Cells" to write "Range("A:A,H:H").Select" | Excel Programming | |||
Hybrid Mode
