How To make any open sheet in WorkBK run Macro.

whatsup · #2 06-21-2014, 07:02 AM

Hi

Keep in mind: Recording a macro is a feature very helpful to get an idea what is required or to figure out methods, properties, ... whatsoever. But the recording also records all your selections you did, and at least that part you have to transform to another syntax.

Now I don't know your macro, but whatever you want the macro to perform you have to address explicity where it should be performed. The right thing would be, to enter a formula in Sheet2:

Code:

Sub EnterAFormula()
ThisWorkbook.Sheets("Sheet2").Range("C3").Formula = "=A1"
End Sub

Though it's not necessary to address "Thisworkbook" if your "Sheet2" is within the active workbook. The same applies to the address "Sheets("Sheet2"), if the Range is within the active sheet.
So probably by now you know what to change in your macro. If not, just post your code, and I will show it on your example.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to make an add-in/global macro	hanvyj	Excel Programming	4	12-14-2012 03:23 AM
Make row in one sheet equal column of another	hypertyper	Excel	6	01-31-2012 03:48 PM
confirmation popup on excel sheet macro	mark-gabb	Excel Programming	3	12-22-2011 01:16 AM
Debug for macro run through button only when sheet protected	leahca	Excel Programming	0	11-24-2011 04:47 AM
copy cell from sheet 2 to sheet 3 macro	slipperyjim	Excel Programming	1	02-18-2010 01:31 AM