Lets say c.address = C1

c.offset(0,1).address = D1
c.offset(0,2).address = E1

Make sense?
--
HTH,
Barb Reinhardt



"ChuckS" wrote:

Hello,
I have a couple of user forms including text boxes that I would like to use
to complete cells in a spreadsheet. I need to look for the next empty cell to
start the data in column a. I have this code working fine but is there a
simple way to increment the c.address by one column marker to shift from a to
b, b to c and so on.