Macro excel 2013 : Failure excution

Question

Hello,
I need some little help about Macro in Excel 2013, I made a simple macro, but I have to select the same cell in excel to do the same work, could I do the same macro on another column or another cell number ?
Any modification on vba basic to execute the same instruction, but on other cells?

haytham amairah · Answer

Hi Mehdi,
&nbsp;
Please show us that macro to figure out how to modify it!
Go to the VBA editor, copy the macro code, and then paste it here in a reply!

mehdi boulifa · Answer

This is a simple exemple, I need to apply it anywhere in the sheet...
Sub CAP() ' ' CAP Macro ' ' ActiveCell.FormulaR1C1 = "=UPPER(RC[-1])" Range("D20").Select End Sub

haytham amairah · Answer

Mehdi,
&nbsp;
Replace that code with this:
Sub CAP()
 Selection = "=UPPER(RC[-1])"
End Sub
You can apply it not only to a single cell but also to a range of cells!

mehdi boulifa · Answer

What about any other macro, I will always use the same cells number !
if I would like to apply the same macro in a different place in the sheet !
it was an example that I sent to you, I want a general method.

haytham amairah · Answer

You have to record a macro and modify it (If that needed) somehow to complete the required work.
&nbsp;
You can use specific properties such as Selection, ActiveCell, ActiveSheet, ThisWorkbook...
You have an option of using Use Relative References which is useful in this context!
Sometimes, you may need to use some advanced tricks!
&nbsp;
This depends on the work that you want to do.

Forum Discussion

Macro excel 2013 : Failure excution

Share

Resources