Thread: Setting a variable using COUNTA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gerrym Gerrym is offline
external usenet poster
  
Posts: 8
Default Setting a variable using COUNTA
Can I set a variable using COUNTA to count non blank rows
and then use the variable in a macro with
ActiveCell.FormulaR1C1 = "=VLOOKUP(RC[-5],LCCUS!
R2C1:VARIABLE,2)"

I need this as the number of rows in the sheet LCCUS can
vary.

TKS
Reply With QuoteReply With Quote