Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
program next column
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
program next column
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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
program next column
I use this kind of thing:
Dim NextCell as range with worksheets("somesheetnamehere") set Nextcell = .cells(.rows.count,"A").end(xlup).offset(1,0) end with with nextcell .value = "stuff in column A" .offset(0,1).value = "stuff in B" .offset(0,2).value = "stuff in C" end with ===== Sometimes, I use: Dim NextRow as long with worksheets("somesheetnamehere") NextRow = .cells(.rows.count,"A").end(xlup).row + 1 .cells(nextrow,"A").value = "a" .cells(nextrow,"B").value = "B" .cells(nextrow,"C").value = "C" end with 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. -- Dave Peterson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
program next column
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 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
how do i program excel to insert a new column monthly | Excel Programming | |||
Need to program a find only in one column | Excel Programming | |||
Program Column B to record numerical range based on number in colm | Excel Discussion (Misc queries) | |||
merging excel program with tdc finance program | Excel Programming |