Posted to microsoft.public.excel.programming

Bob

external usenet poster

Posts: 972

Specifying a range within an array

Can someone kindly tell me how to specify a range within a 2-dimensional
array (e.g., row 1, column 1 through row 1, column 14)? I'm trying to do so
in the following VBA line:

RowHourCellsFound = WorksheetFunction.CountIf(Range(HoursArray(1, 1) & _
":" & HoursArray(1, 14)), "0")

Thanks in advance for any help.

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
How to fix an array or range	delboy	Excel Discussion (Misc queries)	1	February 12th 08 08:14 PM
Range to Array	Gary''s Student	Excel Programming	5	June 7th 07 09:22 PM
copy one array formula to an array range	guedj54	Excel Programming	2	October 29th 06 07:38 PM
Tricky array formula issue - Using array formula on one cell, then autofilling down a range	aspenbordr	Excel Programming	0	July 27th 05 03:59 PM
Range as array	J.E. McGimpsey	Excel Programming	1	September 10th 03 11:06 PM

All times are GMT +1. The time now is 11:25 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us