cell address as variable

How do I get a macro to keep the absolute reference of active cells for use in a cell formula later? i.e. I have cell E11 selected, I want my macro to remember the value in cell E11 and the reference, then move to column A in the same row and make a formula that is = 18 - E11 (which should...

i have no clue to doing this man, i expect the output is to be the right chart, but on the left chart is what i’ve done i want the cell to still remain the same number even the row is deleted and if i add new no. it still going +1 i need your help guys

I am looking for a looping function that will capture cell addresses and plug them into an array. The array then gets used in a formula. I pictured using the offset technique to move the cursor over 2 columns, evaluate if greater than 0, if so store the cell address and then create the formula...

Hi I've read a number of posts and I've got part way through on this problem but not all the way. I have a spreadsheet which has a menu page where the user selects a business unit by inputting a value into a cell (using validation dropdown so spelling is correct) I want this cell selection to...

Hi, I'm wondering if anyone knows how to make a formula to reference a cell based on a solution of another problem. For example, could I do something like this.....? <tbody> A B C D E 1 -2 -3 .11 2 3 -2 .56 3 -1 .18 4 1 .96 5 2 .33 6 3 .85 =if(B6=A2, C6, "") =if(D6=""...

Folks: Looking to modify your code to find the row with "Grand Total" in column B, then Range("A2:H" & LstRow).Copy I tried this code, it only copied 2 rows, definitely not the row with "Grand Total" found in it. How can I fix it? Thank you, Rowland: Sub try_this() 'copy...