Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inserting value at end of range
Hey guys
Lets say I have Range A1:A100 and a textbox(Textbox1). Currently there are values in A1:A25. I need for for TextBox1 value to be inserted in the next empty cell in the range. The next empty cell in the range is A26, so therefor this is where I would like Textbox1.value to be inserted. How would write this? I usualy just do a count formula+1 in any cell and have the vba code refer to that cell as the location for the next value to be inserted, but this can clutter up my worksheet with variables. Thanx Todd Huttenstine |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting a row within a range that is defined in a sum function | Excel Discussion (Misc queries) | |||
Input Boxes 4 Inserting A Range In A Formula | Excel Discussion (Misc queries) | |||
Inserting a range of cells | Excel Worksheet Functions | |||
Inserting selected range into Word document | Excel Programming | |||
excel 97 : automatically inserting a specific value for a range? | Excel Programming |