Using Find in macro to select range of a table

[BHudPE]

I am fairly new to macros, but have been programming with formulas for years,

Using RecordMacro, I am trying to find a table of text, and copy it to another worksheet. I want to copy it as a range, not as rows or columns. Using Find, I can get to the 1st row of the table. Using Find again, I can get to the last row of the table.

What I don’t know how to do next is select the range.

For example; The table is in cells A10:F20. “Start” is in cell A10, and “End” is in cell A20.

Starting from cell A1, how do I find and select the range A10:F20.?

I will be doing this twice in the same macro, as there are 2 tables. Each of the 2 tables has the same “Start” and “End” text, as described above. The 2 tables will not always be located in the same location within the original WkSht.

Thx
BHudPE

[Leith Ross]

Hello BHudPE,

If you have found the starting cell and last cell, set a range object equal to these.

Please Login or Register  to view this content.

[BHudPE]

Ok Thx, I haven't used that yet.

Can the ("A10", "F20") be set by the Find results within the Macro?

[Leith Ross]

Hello BHudPE,

Yes, you can it use Find to return the start and end of the range. The VBA Find Method returns a Range Object. You would need to change the code a little if you use that method.

Please Login or Register  to view this content.

[BHudPE]

Thank you, I was able to figure it out