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