for the risk for hijacking another users thread i thought i'd start a new one on a similar topic.
http://excelforum.com/showthread.php?t=631719

1. i'm curious to know whether a named dynamic range in VBA can overcome the inability of INDIRECT to resolve a dynamic range? that is, define a dynmaic range using VBA, display that range name in say cell A1, then INDIRECT(A1) to utilise the dynamic range?

2. if so, i was thinking of using the standard OFFSET to determine rows and columns, yet now realise that this will not handle data with blank rows/columns. if i have a dataset that is for example cells A1:A10, A:12:A22, A24:A30 what formula should i use to ensure the blank cells are ignored?