| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Row Reference
Can anyone help me with this code?
I'm not sure why it's not working Private Sub MultiPage1_Change() Dim RowNumber As Variant RowNumber = Sheets("Access Upload").ActiveCell.Row TextBox1.Value = Sheets("Access Upload").Range("A " & RowNumber & "") End Sub |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Row Reference
Hi,
Change: RowNumber = Sheets("Access Upload").ActiveCell.Row To: RowNumber = ActiveCell.Row If you need to ensure sheet integrity, activate the sheet first, then get the row: Sheets("Access Upload").Activate RowNumber = ActiveCell.Row HTH. "Przybo" wrote: Can anyone help me with this code? I'm not sure why it's not working Private Sub MultiPage1_Change() Dim RowNumber As Variant RowNumber = Sheets("Access Upload").ActiveCell.Row TextBox1.Value = Sheets("Access Upload").Range("A " & RowNumber & "") End Sub |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
| Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
| Row reference increment but preserve column reference | Excel Worksheet Functions | |||
Linear Mode
