Apply Formula Uptill Last Row

[hecgroups]

Hello Again,

I am seeking for a vba macros on the below mentioned details.

I am trying to apply a formula in comuln G uptill last row based on column A. Means if column A have data till row no. 17 then the fomula will be implemented till row 17 in column G.

I hope it is clear mentioned details for seeking help from a expert user.

Copy of a sample file is attached for your understanding.

[jeffreybrown]

Here is a sample

Please Login or Register  to view this content.

[hecgroups]

Thanks for your reponse Mr. Jeff,

I am applying formula through vba macros recording something like this

Please Login or Register  to view this content.

But it is giving me an error saying "Application-defined or object-defined error".

---------- Post added at 07:04 AM ---------- Previous post was at 07:00 AM ----------

Just now i have tested my formula though vba recording it is displaying the same error.

Please Login or Register  to view this content.

[jeffreybrown]

The formula you have posted within the snippet of code is in R1C1

So, replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

Because this formula is so long I broke it into multiple rows

Please Login or Register  to view this content.

[bonny24tycoon]

This should work fine for you -

Please Login or Register  to view this content.

[hecgroups]

Thanks Bonny.

It works. I have one more request. If a user plugin the deails from column A to Column F the formula will execute automatically. Can it be possible.

[bonny24tycoon]

Yes, it is possible...

Giveme a minute while i put this in a code...

[bonny24tycoon]

Here you go..

I have added a module and a private sub.. You should be fine.. Apply Formula Uptill Last Row.xlsm

[hecgroups]

Thanks for your help. Topic marked as closed and reputation added.