Posted to microsoft.public.excel.programming

GS[_2_]

external usenet poster

Posts: 3,514

Inaccurate count with code

Set rng = wks.Range("A1:A250")
For Each c In rng

Not a big deal but this gets processed every iteration of the loop. You
don't need the 'rng' var...

For Each c In wks.Range("A1:A250")

...since it's the same for every sheet.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

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
inaccurate line chart	Tom H.	Charts and Charting in Excel	3	December 3rd 09 03:22 PM
Inaccurate LAST ROW / LAST COLUMN #	KG Old Wolf	Excel Programming	3	September 24th 09 12:09 PM
Comparing two lists with one being inaccurate	Ditch	Excel Discussion (Misc queries)	3	June 24th 09 02:57 PM
sum inaccurate	Terry	Excel Worksheet Functions	4	March 16th 09 08:43 AM
Source Data Inaccurate on Chart	Bo	Excel Discussion (Misc queries)	1	February 5th 08 12:25 PM

All times are GMT +1. The time now is 06:57 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us