How can I move to a cell and remove the current data in excel?

Get help with using AutoHotkey (v1.1 and older) and its commands and hotkeys
hancre
Posts: 248
Joined: 02 Jul 2021, 20:51

How can I move to a cell and remove the current data in excel?

19 Sep 2021, 21:03

I tried this following code.
But It doesn't work and an error happens.

The error message show <6 '6' runtime error happened. overflow > and the macro for search stopped.
How can i fix the issue? Thanks for any help in advance.
what I want : move to E3 and remove the data to type another text fast.

Code: Select all

Appskey & a:: 
xl.Range("e3").Select
xl.cells.delete
Return
Attachments
temp_0920_002.jpg
temp_0920_002.jpg (38.23 KiB) Viewed 232 times
User avatar
mikeyww
Posts: 26883
Joined: 09 Sep 2014, 18:38

Re: How can I move to a cell and remove the current data in excel?

20 Sep 2021, 05:30

Code: Select all

Appskey & a::XL.Range("e3").Delete, XL.Range("e3").Select

Return to “Ask for Help (v1)”

Who is online

Users browsing this forum: GollyJer, Lamron750, septrinus, shawn_xwang and 242 guests