current cell

Greetings and thanks for all the help. One more here for this projects I have worksheet that has data copied from another and columns updated with a replace function. This works great starting from A2 to the end of rows in A. However I now add data from another sheet to the end of A:900...

No-one ever seems to get anywhere with this so I think I must be missing something obvious. I need get a reference for a specific column and the current row (AAx). I've currently used INDIRECT() but I know thats quite computationally inefficient and I need about 10,000 instances of this formula...

Hello, I was wondering how to create a macro to subtract 1 from the current cell selected in a spreadsheet? I have a daily summary report that I adjust everyday by subtracting 1 from different cells throughout the summary report. I've tried to record a macro but it puts the location of the...

Hello everyone, sorry if this question was asked before - I have searched through the forums and haven't found anything similar. So this is what I'm trying to do: I want to have a button on SHEET01 that (when pressed) will copy the values from the currently selected cells on SHEET01 to the...

Hi.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> Im trying to sum the cell to the left and the cell 2 steps to the left in a excel, I have to paste this code to different places in sheet decided by a macro.<o:p></o:p> I found the formula to be<o:p></o:p>...

I've been searching for hours and gave up which brought me to posting in this forum. Hopefully I'll find some help and become a regular user here! I get new worksheets on a regular basis which are of the same format (same columns with headers) and I have to perform both vlookups and sumifs on...