View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
whitebalance whitebalance is offline
external usenet poster
 
Posts: 2
Default Set a counta function result in a for loop (Macro Excel)

Hi,
I'm trying to use a result from a counta() function.
Is it possible to set i.e.
test = counta(F2:F200)
and then use it as boundary for the for loop:
for x = 1 To test?

regards
Kristoffer