| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I assign a value cell in a column that has a dynamic row va
Worksheets("Address").Range("Y&rwcount").Value = TextBox22.Value
where rwcount (row number) varies depending on the user input and Y is a constant column |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I assign a value cell in a column that has a dynamic row va
Worksheets("Address").Range("Y&rwcount").Value = TextBox22.Value
Try this instead: Worksheets("Address").Range("Y" & rwcount).Value = TextBox22.Value Also, if you want the result to be a number (rather than text), use CLng(TextBox22.Value), CDbl(TextBox22.Value), etc. Hth, Merjet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| assign value to a cell on next column | Excel Programming | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Charts and Charting in Excel | |||
| Help with copying dynamic column selected based on remote cell value and dynamic formula fill | Excel Programming | |||
| Assign column | Excel Discussion (Misc queries) | |||
| looking to assign different numbers in column B to different words in column A | Excel Worksheet Functions | |||
Linear Mode
