Thread: count # of elemnts in a column
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default count # of elemnts in a column
Not sure what you are trying to do, but
instead of: Selection.AutoFill Destination:=Range("g2:gh")
try: Selection.AutoFill Destination:=Range("g2:g" & h)

HTH,
Merjet


Reply With QuoteReply With Quote