Thread: Using a Form to control variable fields.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default Using a Form to control variable fields.
Hi

Get the next row using the below code

intRowB = ActiveSheet.Range("B65536").End(xlUp).Row
intRowC = ActiveSheet.Range("C65536").End(xlUp).Row

If this post helps click Yes
--------------
Jacob Skaria

Reply With QuoteReply With Quote