Posted to microsoft.public.excel.programming

whitebalance whitebalance is offline

external usenet poster

Posts: 2

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
COUNTA Function	Karen	Excel Worksheet Functions	7	November 10th 08 06:39 PM
Counta function	Help	Excel Worksheet Functions	3	July 2nd 08 07:01 PM
Using the COUNTA function	JL1976	Excel Discussion (Misc queries)	1	October 26th 07 01:28 AM
COUNTA function causing syntax error in macro...	Birmangirl	Excel Worksheet Functions	4	February 6th 07 04:04 PM
COUNTA Function not working =COUNTA(C3:C69,"NH")	MikeinNH	Excel Worksheet Functions	2	November 8th 04 01:19 AM

All times are GMT +1. The time now is 10:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us