Introduce a formula next to Active Cell

Hi,

I'm working on a macro but got stock with this. I need the code to add a column to the right of the active cell (which I achieved), then I need to add a formula on the cell to the right of the Active Cell, and below, for as many rows as column A has content (this is the part I need help with.

My current (broken) code is as follows:

Please Login or Register  to view this content.

What do I have to change to achieve this?

Thanks for your help

Hi Sintek!,

Thank you so much for your help! I tried the code, and it works! ... only issue is it goes ahead and adds the formula one extra row at the end. So, if column A has content down to row 15, the code adds the formula to row 16 too (B16). How can this be avoided?

Thanks!

Hi Sintek!

Well, I tried the code, and it both worked and not. Let me explain. Adding that "-1" took care of the extra row having the formula. But, the problem I have now, is that it won't work if the active cell is located at a different row, other than row 2. If the active cell is A5, and I have content from A1 through A10, it will add the formula starting in cell B5, and will add it for as many rows as the ones having content in column A. I do understand that is more related with the first part of the code, asking to count rows in column A. Any idea about how can I avoid that? What I need is that the code counts the rows starting with the Active cell down.

Thanks!

Hi Sintek,

Sorry for delayed response. Got stuck with work this week. First of all, I appreciate you took the time to look into this issue again. I tried the code and it worked, but has a flaw. To better illustrate what I'm trying to do, I'm attaching a sample workbook where I used your code having some sample data in column A & B. The active cell was A5. As you can see, a new column was inserted then the formula added. The only problem is that the last row containing data in column A didn't get the formula in column B. As a reference, I'm adding the same 2 columns to the right of those, where the added date goes all the way down to the last used row in the first column.