| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Active sheet instead of a "sheet1" for Macro
I have this code in a macro:
If Sheets("Sheet1").[A1] = True Then ActiveWindow.SmallScroll Down:=-9 Application.Goto Reference:="R17C3" Range("C11:C17").Select Range("C17").Activate Selection.Copy My questions is how do I make this macro work in any worksheet not only only in sheet1, what do i have to change from "Sheet1" to make it work. thank you, Pamela |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do copy "sheet1!A1+1 in sheet2 to sheet 3 and get "sheet2!A1+ | Excel Discussion (Misc queries) | |||
| Macro to email with "active row" info | Excel Discussion (Misc queries) | |||
| Macro to concatenate into "B1" B2 thru B"x" based on new data in "Col A" | Excel Discussion (Misc queries) | |||
| How do I color code the "SHEET1" Tab in Excel? | Excel Worksheet Functions | |||
| Macro to run on the "Active Sheet" | Excel Discussion (Misc queries) | |||
Threaded Mode
