Del columns and Rows Topic is solved

Get help with using AutoHotkey and its commands and hotkeys
asad41163
Posts: 268
Joined: 29 Jul 2014, 14:31

Del columns and Rows

17 Jun 2019, 08:03

welcome everybody
What is added to the following code
- To delete column C?
- To delete row 12? From the Excel file:

Code: Select all

F5::
oExcel := ComObjCreate("Excel.Application")		; create Excel Application object
oExcel.Workbooks.Add 						; create a new workbook (oWorkbook := oExcel.Workbooks.Add)
oExcel.Visible := 1							; make Excel Application Visible  
oExcel.Range("A1").PasteSpecial(-4104)
;;;;;;;;;;;; ?
return
User avatar
flyingDman
Posts: 491
Joined: 29 Sep 2013, 19:01
Location: Burbank, California

Re: Del columns and Rows  Topic is solved

17 Jun 2019, 09:27

Code: Select all

oExcel.columns("c").delete											;delete column
oExcel.rows("12").delete												;delete row
asad41163
Posts: 268
Joined: 29 Jul 2014, 14:31

Re: Del columns and Rows

17 Jun 2019, 11:37

Hello, flyingDman

Again, all thanks and appreciation to you.

You saved me a lot of time and effort.
thank you very much.

Return to “Ask For Help”

Who is online

Users browsing this forum: cabbagethunder, cadudesun, flyingDman, jbullock35, Lorien, Rohwedder, Xtra and 236 guests