Previous Topic Next Topic

Run a Macro only for specific cells

Closed
PeriGr Posts 11 Registration date Monday July 17, 2017 Status Member Last seen August 12, 2017 - Jul 31, 2017 at 02:45 AM
PeriGr Posts 11 Registration date Monday July 17, 2017 Status Member Last seen August 12, 2017 - Jul 31, 2017 at 04:04 AM
Hello,

can you please help me with one problem I am currently having with Excel Macro? I want to be able to run a macro only for specific cells ... not for the whole sheet of the excel. Is it possible?

1 response

Answer 1 / 1
stankirsolkar Posts 6 Registration date Friday July 28, 2017 Status Member Last seen July 31, 2017
Jul 31, 2017 at 03:21 AM
What does the Macro do? It's difficult to help without having more context.

You will have to change the code and specify the cells in which you want it to run.
PeriGr Posts 11 Registration date Monday July 17, 2017 Status Member Last seen August 12, 2017
Jul 31, 2017 at 04:04 AM
Yes sorry for the vague question! Ok so my macro is responsible for comparing values between two columns of cells and if the diffrence is bigger than 5 , copy pasting the rows that the comparing cells belong to another sheet... So far so good.. I have built it and it works perfectly. But, since I add new rows daily in the basic sheet where I run the macro, I dont want the macro to compare values from previous days every time.. I want it to be able to run for specific cells (without having to change the code each time).. For example, I want to be able to underline or to mouse-choose the rows that I want to be checked, and the macro to run just for them!

Similar discussions

Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Return Seq Values Until Blank value then return different set of seq values
lorieb63 -
TrowaD -

1 response
Fill adjacent cell with number from text answer
MitchP -
vcoolio -

20 responses
What Type does it want? (VBA question)
InsertNicknameHere -
TrowaD -

3 responses