Selecting a portion of a table

D

dpap

Hi,
I want to select, with VBA code in a macro, all the cells fro
cell(5,3) to cell(12,7)
How can I do this ?
thanks in advanc
 
J

Jeff Hall

Why not define a range object that starts at the Start of cell(5,3) and
finishes at the End of cell(12,7)

Then select that object.

If I remember correctly, you may need to reduce the End of the Range by one
character to avoid overlapping into the next cell after (12,7). Try it.

--------------------------------------------------------------------
Jeff Hall MSc MRICS
Director, Eon Commerce Ltd.
http://www.eon-commerce.com

Software available for you to evaluate before buying...
EasyHTML/Help CHM file Editor for MS Word
http://www.easyhtmlhelp.com
--------------------------------------------------------------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top