hi all 
This only selects Column L from the first “block” of selected data, rather than Column L of every block of data, what can I do to selected Column L over all of the data “blocks”?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
Set dRange = rRange.Columns(12)<o></o>
dValue = rRange.Row<o></o>
dRange.Select<o></o>
<o></o>
Where dRange is the range of multiple “blocks”. Incidentally copying the data from dRange to a separate location copies all of the data from across the multiple blocks….<o></o>
This only selects Column L from the first “block” of selected data, rather than Column L of every block of data, what can I do to selected Column L over all of the data “blocks”?<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o></o><o
></o>Set dRange = rRange.Columns(12)<o
></o>dValue = rRange.Row<o
></o>dRange.Select<o
></o><o
></o>Where dRange is the range of multiple “blocks”. Incidentally copying the data from dRange to a separate location copies all of the data from across the multiple blocks….<o
></o>
