Excel Macro [Closed]

Report
Posts
1
Registration date
Wednesday April 23, 2014
Status
Member
Last seen
April 23, 2014
-
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
-
Hello All,
I am trying to create a macro with formula. I need help in there. I have to get a formula for a column for more than one sheet. The formula will be the same but the range that the formula will be used are different. So for example - the formula will be applied on sheet 1 from AN5 to AN50. For sheet two, the same formula will be applied from AN5 to AN70.
Any help in this will be appreciated.
The formula that I am trying to use is =ROUNDUP(IF(AP7=0,0,((AP7)/1.7)+IF(AS7>=18,1,0))+BC7,0)+BA7

Thank you
Shahid

2 replies

Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi Shaleem,

Sorry to inform you that it is not possible to create a macro with a formula.

Besides that it is unclear to me why you want to use a macro.

Best regards,
Trowa
Hello

Then what option do I have with that
I also need another help if on excel sheet I need to highlight certain columns and the criteria is that there is a special wording in Column X, all those rows that have that special word have to be highlighted in a color anything else needs to be remain as is. IS there a easy way to do this
Let me know
I am also available on my cell
[number removed - Privacy]

Thanks
Shahid
Posts
2675
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 5, 2020
448
Hi Shahid,

You say you want to apply a formula to a range. Then enter the formula in the first cell of that range and drag it down to apply it to the rest of the range.

For your second question I would use Conditional format. Where you would use a formula like: =A1="Special word".

Let us know if further assistance is needed.

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!