Thread: How do I assign a value cell in a column that has a dynamic row va
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default 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 With QuoteReply With Quote