Thread: Inserting value at end of range
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
David Turner David Turner is offline
external usenet poster
  
Posts: 50
Default Inserting value at end of range
Ron de Bruin wrote

Range("A" & Rows.Count).End(xlUp)(2) = TextBox1.Value

Curious. What does the (2) after (xlUp) mean?

--
David
Reply With QuoteReply With Quote