jbb897

Thanks for the suggestions, all. Here is the macro below. I don't believe that 1500 milliseconds would be causing any delay or issues. I do have six monitors that all use DisplayLink software/drivers, so perhaps MacroExpress is not fully compatible with this setup and that is causing problems. <REPEAT START Start="1" Step="1" Count="5000" Save="FALSE" Variable="%N[1]%"/> <MACRO PLAYBACK SPEED Speed="0.1"/> <WINDOW ACTIVATE Title="2022-10-11 Endocrinology.xlsx - Excel" Exact_Match="FALSE" Wildcards="FALSE" _IGNORE="0x0006"/> <DELAY Flags="\x02" Time="1500"/> <WAIT FOR LEFT MOUSE CLICK Indefinite="TRUE" Hours="0" Minutes="0" Seconds="0" _ENABLED="FALSE"/> <MOUSE LEFT CLICK _ENABLED="FALSE"/> <TEXT TYPE Action="0" Text="<SHIFT><SPACE>"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<SHIFT><SPACE>"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<CTRL>c"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<CTRL>+"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<ARROW RIGHT><ARROW LEFT>"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<CTRL>c"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<ARROW DOWN><ARROW LEFT>"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<CTRL>v"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<F2>"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<ENTER>"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<ARROW UP>"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<ARROW RIGHT>"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="4"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<ARROW UP>"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="3"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<ARROW UP>"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="2"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<ARROW UP>"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="1"/> <DELAY Flags="\x02" Time="1500"/> <TEXT TYPE Action="0" Text="<ARROW DOWN>"/> <TEXT TYPE Action="0" Text="<ARROW DOWN>"/> <TEXT TYPE Action="0" Text="<ARROW DOWN>"/> <TEXT TYPE Action="0" Text="<CTRL><ARROW DOWN>"/> <TEXT TYPE Action="0" Text="<ARROW DOWN>"/> <TEXT TYPE Action="0" Text="<ARROW DOWN>"/> <DELAY Flags="\x02" Time="1500"/> <DELAY Flags="\x02" Time="1500"/> <END REPEAT/>

Hi all, after I run a simple macro (with the changes being made in Microsoft Excel such as copying and pasting, inserting columns, etc.) I have display problems in Excel. Consistently, Macro Express Pro is typing text and doing other commands in Excel, but if I watch the screen, I cannot see anything being done in Excel on the screen real-time. Then when the macro finishes, if I double click in a cell, or change the maximized Excel window to a different size (drag it to a different screen can do this) suddenly all of the changes the macro has made show up. Any ideas? This only happens with Macro Express Pro and Excel. The fix for me is typically to shut down Macro Express Pro, close down all my open Excel files, and relaunch which is frustrating. Sometimes it is not fixed unless I restart my Windows 10 laptop. Macro Express Pro version is 6.4.0.1 Windows 10 64-bit Thanks!

Hi all - first time poster, and I am fairly new to Macro Express (but I love it so far). I am trying to figure out how to run commands within an Excel spreadsheet, and the goal is to have specific commands like "Enter" or "Arrow Up" increase by one with each Macro pass/repeat. I know I can do this by copying the block of macro commands in Macro Express 500 times, and add an additional "Enter" command or "Arrow Up" command with each subsequent block of commands, but doing it this way is painful. There has to be some kind of "counter" that I can use to do the below...? Pass #1 <TEXTTYPE:<CTRL>c <TEXTTYPE:<ENTER> <TEXTTYPE:<ARROW UP> Pass #2 <TEXTTYPE:<CTRL>c <TEXTTYPE:<ENTER> <TEXTTYPE:<ENTER> <TEXTTYPE:<ARROW UP> <TEXTTYPE:<ARROW UP> Pass #3 <TEXTTYPE:<CTRL>c <TEXTTYPE:<ENTER> <TEXTTYPE:<ENTER> <TEXTTYPE:<ENTER> <TEXTTYPE:<ARROW UP> <TEXTTYPE:<ARROW UP> <TEXTTYPE:<ARROW UP> ...repeating the above 500+ times where "Enter" and "Arrow Up" increase by 1 each repeat. Thanks!