Posted to microsoft.public.excel.programming

external usenet poster

Posts: 1

VBA that recognises the end of a sequence

Hi,

I need some code that 'feels' the output of a web query and the
defines a range/array as a result.

Please see the attached sheet.

Essentially the range that should be defined but the code on th
following example is D5 to P24

i.e. the area in which there are numbers followed by values

Can anyone please help??

Attachment filename: example.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56554
--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to 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
Vlookup function which recognises many dates in one month	Cammy	Excel Discussion (Misc queries)	1	August 3rd 06 01:19 PM
min and max in a sequence	bill gras	Excel Worksheet Functions	11	May 16th 06 11:33 PM
Tab sequence	Cees	Excel Discussion (Misc queries)	2	January 26th 06 06:14 PM
Changing cell contents so that Excel recognises it as a date	Dave Peterson	Excel Discussion (Misc queries)	3	December 9th 05 10:53 PM
Set tab sequence help	tamato43	Excel Discussion (Misc queries)	0	August 25th 05 07:11 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us