| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
++HELP ME PLEASE++ ComboBoxes as a Variable to Select Sh
Dim LastRow As Object ShtName = ComboBox66.Text Set LastRow = Sheets(ShtName).Range("A400").End(xlUp) LastRow.Offset(1, 0).Value = TextBox1.Text LastRow.Offset(1, 1).Value = TextBox2.Text LastRow.Offset(1, 2).Value = TextBox3.Text the above is what I now have... but now I get "Runtime error '9' " - Script out of Range, and the yellow bar of hate comes up on the Set LastRow line... The little debugger boxes that come up when you hover are telling me that all the stuff you've given so far is kicking along and working really well... what's up now? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a variable range | Excel Worksheet Functions | |||
| select cell by variable name | Excel Discussion (Misc queries) | |||
| Use a Variable to select a range | Excel Discussion (Misc queries) | |||
| add new sheets in a workbook with new sheets being a variable | Excel Discussion (Misc queries) | |||
| Select workbook with variable name. | Excel Programming | |||
Threaded Mode
