RE: program next column

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Barb,
Thank you I knew I had done this before but I was going brain dead, it works
perfectly as you suggested
c.offset(0,1).value = Textbox2.value

Chuck

"Barb Reinhardt" wrote:

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 spread***. 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.
.

Quantcast