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

  • Thread starter Thread starter russellmz
  • Start date Start date
R

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!
 
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
 
Back
Top