elegant, non-invasive, security-conscious solution...

@thepro08

3 жыл бұрын

yes just install random exes from youtube....

@glvignesh

3 жыл бұрын

@@thepro08 its not even an .exe file. Its just an excelsheet

@rortiz77

Жыл бұрын

@@glvignesh which contains a virus or code to download it.

@DonGPTO

Жыл бұрын

@@rortiz77 Don't download the file, you can always pause the video and type the code by yourself.

@rjelsanpedro

4 сағат бұрын

Do you have a code with automatic left click?

This is brilliant! You're brilliant! Thank you for sharing!!

Very nice, Don. Had to type it manually. Botched several lines, but was able to find the mistakes.

Thank you very much for this! I work from home and my company's laptop is programmed to just lock the screen after 2 mins of inactivity, so this save a lot of hassle!

Excellent Don, You're brilliant! Thank you so much for sharing this video!

@DonGPTO

2 жыл бұрын

My pleasure!

Hi Master Don, Great AFK, appreciate your sharing the script and hints. I made it works ! Very helpful for these days stressful times... Keep posting new ideas, please. Stay safe, Ben

@DonGPTO

4 жыл бұрын

Glad it helped!

Thanks! Greetings from Argentina!

Amazing! So simple, thank you for sharing!

@DonGPTO

3 жыл бұрын

You are welcome!

Thanks a ton Don!

WFH just got a lot better! No more screen lock, Away status, or VPN drop. Thanks

Thanks a lot for your file! It will be so helpful 💜

Thank you so so much! This is much need during WFH! You are 🔥

@DonGPTO

3 жыл бұрын

You are so welcome!

@shiv.s.jamwal

3 жыл бұрын

It is not working for me, can you guide how did you get it right? I downloaded the 64 bit excel file, ran the macro and it is moving the cursor but system is logging off after sometime and activity isn't getting recorded.

Thank you so much for sharing this video Don. Liked & subbed.

@DonGPTO

2 жыл бұрын

Awesome, thank you!

Pure beauty! Thank you!

@DonGPTO

3 жыл бұрын

My Pleasure!

Love your work.. Neat and simple. File download was a bonus.

@DonGPTO

3 жыл бұрын

Awesome, thank you!

@dans6562

3 жыл бұрын

@@DonGPTO where is the file download? New to this..

You are an honest to God lifesaver.

Amazing! It really works

This is neat! Thanks!

Wow, this is really cool macro. Thanks ! I checked your channel and it seems you are not teaching people about Excel macro. Would you mind sharing where you learnt excel macro ? I would like to improve my skill on this if possible. Thanks in advance.

thank you so much for the video

Thank you for sharing; would you happen to know if this would work when running another macro?

Thanks!! this is really helpful!

@DonGPTO

3 жыл бұрын

Glad it was helpful!

Excellent - you are a genius! so useful

@DonGPTO

10 ай бұрын

Glad it was helpful!

This is brilliant thank you - stops my computer locking whilst I am reading. It would be perfect if numlock was activated twice (to return numlock to original state) or a different key was used (I've seen other programmes use F13). Thanks again

@DonGPTO

2 жыл бұрын

I'm glad you liked it! ... Numlock is in fact activated twice, this was considered.

Excelent work

Works on MS Teams to keep status from resetting. Thanks Don.

Very helpful 👍

Thank you so much!!!

Hey Don, new sub here, love the content!!! I had a question would this work for excel 2010?

@DonGPTO

3 жыл бұрын

Hi MIC, yes it should work.

Bro you are a genius

Hey there kind sir! How can we extend the time that the mouse cursor moves? Or how can we set the "Time to Activate" by half a second? Thanks for your brilliant idea!

Thank you, sir! Much appreciate it! =)

@DonGPTO

3 жыл бұрын

You're welcome!

Well Done A bit over complicated I left only the Numlock to have the keystroke, need to increase the time to avoid "sticky key" works fine, it should be work in the background. The Download is a bonus!!!!

Thanks, very helpful

@DonGPTO

3 жыл бұрын

You're welcome!

Just the best👌👌

Thanks for your time and great videos. I hope you are doing well. I have an excel question. I am entering R or L only for Right or Left in excel (10). That is used in counting and other stuff. But it is very annoying hitting R [enter] L [enter] 50 times. Can you please tell me how to just hit my data (L or R) and not enter and have it enter and go down to the next cell. It would be so much faster and more accurate for me to just hit one letter and have it advance to the next downward cell. Thanks for any help you can give me.

I downloaded the file but get the following error message "Compile error: Cannot define a Public user-defined type within an object module" also the following section of the code is highlighted with this error "Public Type POINTAPI" any suggestions?

This is awesome! i get annoyed when i'm reading work file on paper and my screen keeps locking when i actually need to refer to internet while reading my materials. thanks! but i wonder does it still run if we're also working on word documents? ie, does it run on background?

@DonGPTO

4 жыл бұрын

Yes it does run while working on word documents.

@xlncplays7369

4 жыл бұрын

Just use caffeine software if you can. No need to use excel if its your personal computer

What code can I add or need to change if I wanted to type 3 short sentences when the mouse starts to move

You are life saver 😁😁

If you run this in a VMware, there is any way to run it and keep running when you are out of the virtual machine windows? Great tutorial, thanks!

@DonGPTO

3 жыл бұрын

I really don't know how excel macros behave in a virtual machine, I've never tried it.

Thank u so much ❤️.

@DonGPTO

3 жыл бұрын

You're welcome 😊

Hey i wanted to change the code a bit and instead of activating the numlock i would like it to press the 1 and the 2 keys, except when i try to run the code it does not click them

"Damn man you're ALWAYS at your computer! Even after hours!?" "What can I say.. I'm a smart.. I mean hard worker" Thank you sir. Works just like the video.

Thank you so much

@DonGPTO

3 жыл бұрын

You're most welcome

brilliant

Can you please help how can I create this? My organization don't allow me to get files from external source. I have written the whole code in macro but not working. Showing runtime error 9 Subscript out of range

Hello, how are you the macro helped me a lot but I needed to close it at a certain time, because the next macros (spreadsheets) do not open to run while the macro mouse is running, thank you very much

@DonGPTO

4 жыл бұрын

Hello, you can include the following instruction at the end of the sub before the Loop instruction: If Format(Worksheets("Sheet1").Range("B6").Value, "hh:mm:ss") = "00:00:19" Then End And make sure to update the "certain time" you require in the "00:00:19" as with the way it is written it will end the macro at 19 seconds. You will have something like this at the end: GetCursorPos lngCurPos x2 = lngCurPos.x y2 = lngCurPos.y If Format(Worksheets("Sheet1").Range("B6").Value, "hh:mm:ss") = "00:00:19" Then End Loop End Sub

Debería dar un curso de Excel en general !! ya que es un programa de los mas usados en el trabajo!!

Hi, this orogram worked great for the last 2 years.. but stopped last year.. can you fix..? this happened to other users in the last few days... the lock screens still appear and cursor changes to away after 8-9 minutes again... thanks!

I got a run time error “file not found: user 32”. Any advice? Thanks

Hello Master IT , I am getting error 438 Is that because I am on laptop with touchpad mouse, even I have attached regular optical mouse to USB port Msg: Object does not support this property or method. Does it require upgrade to 64bit ver ? Thank you Ben

@DonGPTO

4 жыл бұрын

I am not sure but in the comments you I already addresses the 64bit version.

This works great! One question - I thought the code was to press numlock TWICE which would put the setting back to original. It seems to only press numlock once, which is turning on and turning off my numlock every time it is activated. Is there a way to fix this?

@DonGPTO

3 жыл бұрын

If you look at the code you will see this instruction twice: --> SendKeys "{NUMLOCK}", True

@JayStanLee

3 жыл бұрын

@@DonGPTO Thanks! I did originally try making the sleep instruction incrementally up to 500 and still no fix. I tried deleting the second line of numlock press to only have one. I also tried adding a third line of numlock press as well. In the end I just deleted the numlock press all together as you recommended. All in all this is still an awesome solution to a minor problem without buying any usb sticks or downloading unsafe programs. Thank you!

Thank you for the great tutorial. Where do i download the code please?

@DonGPTO

4 жыл бұрын

Download file here: mega.nz/file/fJoh1A6C#LjygnvdOqXU8BI6Oes_GSUgnHabAvMnyx4zCoAUX6hQ

@rcana5803

4 жыл бұрын

@@DonGPTO : Thanks!

Dear I’m running this on my MacBook Pro but there is an error pop up showing “ error ‘53’ file not found User32” could you please help us to fix it ?

@eterofwerlds6433

3 жыл бұрын

theres a simple solution which is to just stop using a mac

@hkrish26

3 жыл бұрын

I have the same issue. its not working on macbook pro

I was able to download the file, but when I click RUN it doesn't move cursor. What should I do differently or what am I forgetting? TY in advance!

PLEASE UPDATE FOR 64 BIT - ERROR - "The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then mark them with the PtrSafe attribute."

@DonGPTO

3 жыл бұрын

Read the comments, I already answered this question.

@matthewalkman386

3 жыл бұрын

@@DonGPTO @DonGPTO ERROR - FILE NOT FOUND: USER32 RUNTIME ERROR 53 DOESNT WORK!!!!

I am getting this error "compile error can't find a public user defined type within an object module". It stops at Public Type POINTAPI. Any ideas ? Thanks !

Amazing! I have having an issue that after the macro is active and the cursor is moving side to side, it's almost like it is stuck in that motion and cannot move the mouse until I either tab back into excel file or if I am already in the file the double click does work. However, before I regain control of the mouse the excel file does not respond for a few seconds. It also looks like the mouse left click is not activating. Windows 10 Machine x64

@domination686

3 жыл бұрын

Solved: Mouse move counters I and J are set to high. reduce for the length that suites your needs.

@DonGPTO

3 жыл бұрын

Nice tweak according to your needs!!

Is there a way to auto click instead of auto move with the help of macro in excel?

thanks!!

@DonGPTO

3 жыл бұрын

You're welcome!

hey getting an error saying macro not avaliable or absent. This is not working in my system. please help

This is outstanding codings, Thanks sir Can I have code for only mouse move Seconds Elapsed time only with run macro after completing 10 seconds of not moving mouse cursor?

does this help with keeping you active in teams as well?? I tried one macro and it didn't work, teams went on away before the macro finished

@DonGPTO

2 жыл бұрын

I have not tried it with teams. Check the teams timer for going into away mode and set the macro timer to activate before that time and see if it works.

I get and error "Run time error 53, file not found user32 , and when I select debug in popup window, it shows it stopped at GetCursorPos lngCurPos

Where it's declared in the code when to stop the execution? I want to make it stop after certain period of time.

@DonGPTO

3 жыл бұрын

It's not declared anywhere but you can compare the "Total Run Time" counter vs the time you want and if true then "End". (in example below 12:25:00 AM is equal to 25 minutes, 1:38:00 AM is equal to 1 hour and 38 minutes, and so forth) Include new code between Do and DoEvents: Do If Worksheets("Sheet1").Range("B6").Value = "12:25:00 AM" then End End If DoEvents . . .

Hello DonGPTO, thanks for the video. Can you share the 64bit file? the mega is link is no longer valid. thanks again

@DonGPTO

3 жыл бұрын

Hi Sarf, link to the 64bit file in the description is working I just tried it.

Does this work on prohance tracking software???

i wrote it from your clip but i have an error: does not recognize the "function" : SetCursorPos (sais is not defined). Also not sure which one is 1 or L small caps (l) of I. Once u said excel none - so i assume xlnone has L and xlcontinuous is also L :D

Is there a work around for a Mac system?

Most of the time the macro doesn't work the computer gets locked but after unlocking the mouse moves. How to fix

Hi, I tried your VBA but I am getting an error message. "The code in this project must be updated fo use on 64-bit systems. Please review and update Declare statements and then mark them with PtrSafe attribute". any ideas how the vba need to be updated

@DonGPTO

4 жыл бұрын

Hi, scroll through the comments I already answered that.

@ABlueberryMuffin

3 жыл бұрын

@@DonGPTO why not just post it as its own comment so it is at the top?

I want to know this code working for OpenOffice spreed sheet

It looks good Thank youCan you help me I type the code as it is but, I am getting error "can't execute in break mode""compiler error Loop without do"

@DonGPTO

5 жыл бұрын

Link to file in the description.

I've gotten the code to work and it helps to prevent my screensaver in Windows 7, but Windows 10 just ignores it and goes to screensaver anyway. Am I doing something wrong?

@DonGPTO

3 жыл бұрын

I actually have it working on Windows 10, not sure why it wouldn't work on your machine. Please try it on a different Windows 10 machine to confirm.

@DigitalRiesNL

3 жыл бұрын

@@DonGPTO I found an easy alternative, a freeware software program called Caffeine which does the same thing. Thanks anyway 👍🏻

Just tied my mouse on the window curtain. Now it moves automatically when the curtain is pushed by air.

Is that work in the game fps like point blank ?

It would be nice if it would change the time randomly each cycle so it is not easily predicted, and also it would be nice if it would jiggle the mouse randomly as well (not in a linear left to right or even top to bottom each time the same amount). I've been trying to figure out where I need to include a RND() function in it to make it more random.

it does not work on office 2019, eroor: compile error: the code in this project must be updated to use on 64 bit systems. Please rewiev and update Declare statements and then mark them with the PtrSafe attribute. Any help ?

@DonGPTO

4 жыл бұрын

Scroll through the comments, I've already answered this. Thanks!

@IcanCwhatUsay

3 жыл бұрын

@@DonGPTO Put the answer in the description then instead of having us scroll through 10000s of useless comments

@DonGPTO

3 жыл бұрын

Done

Hi Don. For some reason I am unable to download. It says file don't exists

@DonGPTO

4 жыл бұрын

Hello, I just downloaded it successfully link is working. You may want to try with another computer, Thanks.

Any way too reduce the time of mouse movement ...i mean the mouse moves for like 20 -30 sec...i wana reduce it to 5 secs

@DonGPTO

3 жыл бұрын

Check the "For" loops and reduce the values.

I get error: code for this project must be updated for 64 bit systems. Please review and update the declare statements and then mark them with the PtrSafe attribute.

@DonGPTO

4 жыл бұрын

Hi, Change "Private Declare Function" for "Private Declare PtrSafe Function", "Private Declare Sub" for "Private Declare PtrSafe Sub", "Declare Sub" for "Declare PtrSafe Sub", and "Public Declare Function" for "Public Declare PtrSafe Function". I think that will solve the 64 bit system issue..

@renerivero8691

4 жыл бұрын

Fantastic

@MrNsolis

2 жыл бұрын

@@DonGPTO Confirmed, this fixed the 64bit problem!

can you update for 64 bit versions of excel?

@DonGPTO

4 жыл бұрын

Hi, Change "Private Declare Function" for "Private Declare PtrSafe Function", "Private Declare Sub" for "Private Declare PtrSafe Sub", "Declare Sub" for "Declare PtrSafe Sub", and "Public Declare Function" for "Public Declare PtrSafe Function". I think that will solve the 64 bit system issue..

@matthewalkman386

3 жыл бұрын

@@DonGPTO ERROR - FILE NOT FOUND: USER32 RUNTIME ERROR 53

this bit of code is helpful. however it is causing CPU to do some heavy lifting. check for yourself, bring up the task manager after starting it. while this is running, my computer fans ramp up and started pumping out quite a bit of heat. will post a remedy if i find one.

@user-od3dh1nr4c

4 жыл бұрын

thanks again DonGPTO. without having a Sleep command in the loop it is causing the CPU(s) to run this loop as fast as they can. adding "Sleep 250" slows this loop down so it only runs 4 times per second. would really help people that won't read the comments if you were to update the code in the download.

@user-od3dh1nr4c

4 жыл бұрын

**** to see where i've added it the code is below. 5 lines up from the bottom you'll see it **** Sub MouseMove() Dim lngCurPos As POINTAPI Dim StartTime As Double Dim SecondsElapsed As Double Dim MinutesElapsed As String StartTime = Timer StartTime1 = Timer GetCursorPos lngCurPos x2 = lngCurPos.x y2 = lngCurPos.y Worksheets("Sheet1").Range("B1:B6").Value = "" Worksheets("Sheet1").Range("A1").Value = "Cursor Position" Worksheets("Sheet1").Range("A2").Value = "Time Elapsed" Worksheets("Sheet1").Range("A3").Value = "Seconds Elapsed" Worksheets("Sheet1").Range("A4").Value = "Time Remaining" Worksheets("Sheet1").Range("A5").Value = "Times Activated" Worksheets("Sheet1").Range("A6").Value = "Total Run Time" Worksheets("Sheet1").Range("A7").Value = "Time to Activate" Worksheets("Sheet1").Range("B4").Interior.ColorIndex = xlNone Worksheets("Sheet1").Range("B7").Interior.ColorIndex = 6 Worksheets("Sheet1").Range("A1:B7").Borders.LineStyle = xlContinuous Worksheets("Sheet1").Columns("A").ColumnWidth = 21 Worksheets("Sheet1").Columns("B").ColumnWidth = 15 Worksheets("Sheet1").Columns("B").HorizontalAlignment = xlCenter If Worksheets("Sheet1").Range("B7").Value = "" Then Worksheets("Sheet1").Range("B7").Value = "12:01:00 AM" End If Worksheets("Sheet1").Range("B7").NumberFormat = "hh:mm:ss" SecondsToActivate = Worksheets("Sheet1").Range("B7").Value SecondsToActivate = Hour(SecondsToActivate) * 3600 + Minute(SecondsToActivate) * 60 + Second(SecondsToActivate) counter = 0 Do DoEvents GetCursorPos lngCurPos x1 = lngCurPos.x y1 = lngCurPos.y If x1 x2 Or y1 y2 Then StartTime = Timer Worksheets("Sheet1").Range("B4").Interior.ColorIndex = xlNone End If SecondsElapsed = Round(Timer - StartTime, 2) MinutesElapsed = Format(((Timer - StartTime) - 0.5) / 86400, "hh:mm:ss") Worksheets("Sheet1").Range("B1").Value = "X: " & lngCurPos.x & " Y: " & lngCurPos.y Worksheets("Sheet1").Range("B2").Value = MinutesElapsed Worksheets("Sheet1").Range("B3").Value = SecondsElapsed Worksheets("Sheet1").Range("B4").Value = Format(((SecondsToActivate - SecondsElapsed) + 0.5) / 86400, "hh:mm:ss") Worksheets("Sheet1").Range("B5").Value = counter Worksheets("Sheet1").Range("B6").Value = Format(((Timer - StartTime1) - 0.5) / 86400, "hh:mm:ss") If SecondsElapsed Worksheets("Sheet1").Range("B4").Font.Color = RGB(0, 0, 255) ElseIf SecondsElapsed >= SecondsToActivate * 0.7 And SecondsElapsed Worksheets("Sheet1").Range("B4").Interior.ColorIndex = 6 Worksheets("Sheet1").Range("B4").Font.Color = RGB(0, 0, 255) ElseIf SecondsElapsed >= SecondsToActivate * 0.8 And SecondsElapsed Worksheets("Sheet1").Range("B4").Interior.ColorIndex = 46 Worksheets("Sheet1").Range("B4").Font.Color = RGB(0, 0, 255) ElseIf SecondsElapsed >= SecondsToActivate * 0.9 And SecondsElapsed Worksheets("Sheet1").Range("B4").Interior.ColorIndex = 3 Worksheets("Sheet1").Range("B4").Font.Color = RGB(255, 255, 255) ElseIf SecondsElapsed >= SecondsToActivate * 0.95 Then If SecondsElapsed Mod 2 = 0 Then Worksheets("Sheet1").Range("B4").Interior.ColorIndex = xlNone Worksheets("Sheet1").Range("B4").Font.Color = RGB(255, 0, 0) ElseIf SecondsElapsed Mod 2 0 Then Worksheets("Sheet1").Range("B4").Interior.ColorIndex = 3 Worksheets("Sheet1").Range("B4").Font.Color = RGB(255, 255, 255) End If End If If SecondsElapsed >= SecondsToActivate Then Worksheets("Sheet1").Range("B4").Interior.ColorIndex = xlNone Worksheets("Sheet1").Range("B4").Font.Color = RGB(0, 0, 255) For i = 1 To 500 For j = 1 To 100 SetCursorPos x1 + j, y1 Next j For j = 99 To 0 Step -1 SetCursorPos x1 + j, y1 Next j Next i mouse_event MOUSEEVENTF_LEFTDOWN, 0&, 0&, 0&, 0& Sleep 100 mouse_event MOUSEEVENTF_LEFTUP, 0&, 0&, 0&, 0& Sleep 100 SendKeys "{NUMLOCK}", True Sleep 100 SendKeys "{NUMLOCK}", True Sleep 100 StartTime = Timer counter = counter + 1 End If GetCursorPos lngCurPos x2 = lngCurPos.x y2 = lngCurPos.y Sleep 250 Loop End Sub

@DonGPTO

4 жыл бұрын

Thanks Tim for this contribution, I tested it and brought down the CPU processing for the macro from 47% to 2%, this is awesome! I will update the download file and repost it.

@Rackmani

10 ай бұрын

@@user-od3dh1nr4c Bravo! - (you mean 3 lines up from the bottom not 5 I guess though)

I keep getting the debug error after running 45 mins. Any words of advice on how to fix it?

@DonGPTO

3 жыл бұрын

If you are using the 64bit version, try with the 32bit version see if it works better. Not sure why you are getting that error you may want to google it.

The link provided in description does not work - It says page can't be displayed. Please share correct link.

@DonGPTO

4 жыл бұрын

It's working I just tried it.

Its Working well for puting me online throughout , But in Sapience Buddy software that time is not calculated. Is there any solution on it?????????

@DonGPTO

3 жыл бұрын

I don't know what Sapience Buddy is, sorry.

@anujsingh3926

3 жыл бұрын

@@DonGPTO Sapience buddy is time tracking software used in IT companies to track productivity of employees and your macro code works fine but sapience is not capturing time if you left your system idle

I downloaded the file but get the following error message "Compile error : Cannot define a Public user-defined type within an object module" also the following section of the code is highlighted with this error "Public Type POINTAPI" Any suggestions please ?

@DonGPTO

3 жыл бұрын

Not sure why you are getting this error, you may want to google it to find the answer.

hola, muy util video, saludos de veracruz :)

@juarez9705

7 жыл бұрын

Yo soy de veracruz V:

I downloaded the 64 bit file, but for some reason it does not click on the left mouse button, however, it does move the cursor. After the macro moves the cursor, the cursor turns into a blue circle and Excel doesn't respond for about 5 seconds. Then, it starts the cycle again. Do you know how this can be fixed?

@DonGPTO

3 жыл бұрын

Left mouse button is working try on another PC to check. To decrease the time the cursor moves modify I and J variables as required, see comment for this in video.

@sagarsrivastava8711

Жыл бұрын

Hi, did you find any solution for it? I'm having same issue...the click part is not happening.

@luciacataldo2532

Жыл бұрын

Same guys :( any solution so far?

Download the file and open in Excel hit the run but got an error. Compile error: The code in this project must be updated for use on 64-bit systems. Please review and update Declare statement and mark them with the PtrSafe attribute. Can anyone help? Thanks

@omkarkhanvilkar2139

3 жыл бұрын

same issue

@karenclark2030

3 жыл бұрын

This is an older video

@DonGPTO

3 жыл бұрын

Check the comments I already answered this question indicating the fix.

@DonGPTO

3 жыл бұрын

Check the comments I already answered this question indicating the fix.

@fgtechtips

3 жыл бұрын

@@DonGPTO why dont you update the video description then rather than having all reading all comments ?

After a few times that it gets activated, it stops as it kind of "select" the cells and it does not continue to activate unless I press a couple of times the left click of the mouse.

@williamphilbin1867

3 жыл бұрын

after a couple months of success, this started happening to me

@JoseReyes-jq1cv

3 жыл бұрын

@@williamphilbin1867 just open another excel sheet. Activate the macro and open another excel sheet and leave your mouse on that excel sheet. Problem solved.

@williamphilbin1867

3 жыл бұрын

@@JoseReyes-jq1cv I see what you mean there. that is a nice work around, but my issue is a bit different. after the timer goes off, it will move the mouse until Excel (Not Responding) and then the mouse selects the cell it is hovering over which stops the macro. The macro works on my personal laptop still but all of sudden not on my other

I copied and pasted the code and I am getting a Runtime error 53 - File not found User32. I am going out on a limb that this error is because I am on a mac. Can you confirm? @donGPTO

@DonGPTO

3 жыл бұрын

I tried it on my wife’s mac and I get the same error. This seems to be an error with windows user32 API which are not compatible with mac. Sorry there’s nothing I can do. You may want to try and google for a possible solution to this, not sure there is.

you can make the mouse do the scroll action?

@DonGPTO

3 жыл бұрын

Yes, that is also possible.

1004I have double checked and have all the correct data yet get an error - unable to set HorizontalAlignment property of the Range class - run-time error

@DonGPTO

3 жыл бұрын

Try downloading the file and check.

Hi, i am unable to download file can anyone help me

I got the file but the Marco is not on it so it doesn’t work what am I doing wrong?

@DonGPTO

3 жыл бұрын

Check video to enable developer tab. File must be saved as is.

If I reduce to icon the excel page I get a debug error

:( i cant dowload aything on my laptop - can i have the script for 64 pls?

Got an error compile error loop without do .. first time doing vba can you help please?

@DonGPTO

2 жыл бұрын

Review the code line by line and you will find the error.