macros excel vba

I have the following code that is supposed to stop running when the active cell contains the text "Stop", but it doesn't stop. I have several macros designed to stop in the exact same way and the do stop, but this one doesn't. Can anyone tell me why it keeps going? Here is the code: Sub...

Hi everybody, I am new to Macros and VBA in excel and just know few basics. Please anyone kindly help me with this query. I have workbook in which there are 3 sheets named as Summary(sheet1), Detail(sheet2), Data(sheet3) No my query is how to copy values from Data i.e Sheet 3 (B12, D12, E12...

I am trying to move a whole row(B thru K of the row) to a different sheet when in column (B) on worksheet named Promises, you put either; PAID which would move the row to worksheet named Kept; BROKEN to worksheet named Broken; FOLLOW UP to worksheet named Followup. On the next blank line in...

I appreciate if someone can advice how to convert the below windows code to work under Mac Machine as well , as it is works perfectly on Windows but not on MAC machine Public Function giveMeValue(ByVal link As Variant) As Variant Set htm = CreateObject("htmlFile")...

Good afternoon chaps, I have an excell workbook which I'm trying to apply 2 events codes under the same object so I found some help and came up with this: Private Sub Worksheet_Change(ByVal Target As Range) Call Macro1(Target) Call Macro2(Target) End Sub Sub Macro1(ByVal Target...

Hi, I keep getting this error when I run my macros. It works fine the first time I run it, but if I run it again it gives me this error. My code is pasted below....its very long I hope you can make sense of it. I tried to fix the problem using the function clearclipboard but it didn't...