View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JPL[_3_] JPL[_3_] is offline
external usenet poster
 
Posts: 1
Default 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