Thread: How to transfer the length of one column to a formula in Visual ba
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kanga 85 Kanga 85 is offline
external usenet poster
  
Posts: 34
Default How to transfer the length of one column to a formula in Visual ba
I have a column A of variable length (say 100 cells). I have a formula in J2
which I wish to pull down for that number of cells.

Range ("J2").Select
Selection.Autofill Destination:=Range("J2:J101"), Type:=xlFillDefault.

How do I get the length of Column A to replace the term 'J101' in this
formula?

Thanks
Reply With QuoteReply With Quote