Home |
Search |
Today's Posts |
#6
![]() |
|||
|
|||
![]()
So your formula works great now that I moved the True/False to column "A"
The only other think is my Macros I created to copy and paste from Sheet1 to sheet2 stops with an error and will not continue to loop the checkforsomething. Any ideas on how to fix it so after my macros is finished that it continues on with the one you gave me? Here is my code Sub Move() ' ' Move Macro ' ' Selection.End(xlToLeft).Select Selection.End(xlToLeft).Select ActiveCell.Offset(0, 1).Range("A1:C1").Select Selection.Copy Sheets("BlankStickers").Select ActiveCell.Offset(-2, 0).Range("A1").Select Selection.End(xlDown).Select Selection.End(xlDown).Select Selection.End(xlUp).Select ActiveCell.Offset(1, 0).Range("A1").Select ActiveSheet.Paste Sheets("File").Select End Sub It stops on Sheets("File").Select |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Assign different macros for True/False button | Excel Discussion (Misc queries) | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Discussion (Misc queries) | |||
What's the best way to toggle between true and false in Excel? Hiall, My excel work involves a lot of toggling between true and false (booleantypes) ... and it's very repetitive... Is there a way to select a bunch ofcells, and press a key short-cu | Excel Programming | |||
Linking check boxes so if one is true the other shows false | Excel Discussion (Misc queries) | |||
True / false statements in Macros | Excel Programming |