excel range: how to tell it to move one row down?

16 May 2006 6:02 AM

russellmz

I want to search for the end of a row. There will be a bunch of entries
on each column then on the first blank I want to add something to that
cell. Since ".range" uses a coordinate system with "A1", "B1", etc. how
do I increment the letter coordinate?

Or do i use something else?

Thanks!

16 May 2006 6:53 AM

R. MacDonald

Hello, russellmz,

There might be better newsgroups to post an Excel question in, but...

There are a number of alternatives you might use. Look at the "Cells"
property of Range for an idea. The "Offset" property can also be
helpful in some circumstances.

In order to quickly find the last used cell, you may find the "End"
property to be helpful. Also, the Worksheet "UsedRange" property can be
helpful in limiting your searches if there are empty cells in the
intervening spaces.

Cheers,
Randy

russel***@gmail.com wrote:

Show quoteHide quote

> I want to search for the end of a row. There will be a bunch of entries
> on each column then on the first blank I want to add something to that
> cell. Since ".range" uses a coordinate system with "A1", "B1", etc. how
> do I increment the letter coordinate?
>
> Or do i use something else?
>
> Thanks!
>