How do I assign a value cell in a column that has a dynamic row va

's Computer Specifications

Worksheets("Address").Range("Y&rwcount").Value = TextBox22.Value

where rwcount (row number) varies depending on the user input and Y is a
constant column

's Computer Specifications

> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to locate a cell with dynamic column value	Terence C	Microsoft Excel Programming	2	5th Nov 2009 04:36 AM
assign value to a cell on next column	cesgonzalez@aquanima.com	Microsoft Excel Programming	2	30th May 2006 05:27 PM
Help with copying dynamic column selected based on remote cell value and dynamic formula fill	ers	Microsoft Excel Discussion	0	1st Mar 2006 01:05 AM
Help with copying dynamic column selected based on remote cell value and dynamic formula fill	ers	Microsoft Excel Programming	0	1st Mar 2006 01:05 AM
Help with copying dynamic column selected based on remote cell value and dynamic formula fill	ers	Microsoft Excel Charting	0	1st Mar 2006 01:05 AM