Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Return Current Column Letter and Row Number
Hi,
Let's say cell B3 is currently selected. I want VBA to be able to type in the cell, "=INDEX(B3,-1,0)+7". Cell B2 has a date in it, and I want cell B3 to contain the date that is 7 days later by using the INDEX function. However, when I run the VBA, I won't know what specific cell I'll currently have selected (other than the column, which will always be B). It will be different every time. Any suggestions about how I can come up with the "B3" part of the INDEX function? This is sort of a VBA and a function question, so I hope it can be answered in this forum. Thanks, Carroll Rinehart |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Function that will look at letter in a column and return a number | Excel Worksheet Functions | |||
Column() to return a letter instead of a number? | Excel Worksheet Functions | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Return number of current sheet | Excel Worksheet Functions | |||
How to return the row number or column letter as a variable? | Excel Programming |