Search found 74 matches

by inseption86
06 Jun 2018, 14:24
Forum: Ask For Help
Topic: Autofilter.Sort
Replies: 1
Views: 219

Autofilter.Sort

Hi, please help

how it will look for ahk ?:

ActiveSheet.AutoFilter.Sort.SortFields.Add Key:=Range ("A:A"), SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:= xlSortNormal
ActiveSheet.AutoFilter.Sort.Apply


[codexl.ActiveSheet.Range("A2:AA2").AutoFilter(2, .???)?????/
by inseption86
31 May 2018, 10:48
Forum: Ask For Help
Topic: Filtering a period by date from inputbox AHK Topic is solved
Replies: 2
Views: 305

Re: Filtering a period by date from inputbox AHK Topic is solved

Thanks, I wrote so, it is work, but ">=" and ">=" hinder me inputbox, AutoFilter1, % Xl.ActiveWorkbook.Name, % "Выбрать начальную дату", , , , , , , , >=01.12.2017 ; выбор даты inputbox, AutoFilter2, % Xl.ActiveWorkbook.Name, % "Выбрать конечную дату", , , , , , , , >=31.12.2017 ; выбор даты xl.Acti...
by inseption86
31 May 2018, 09:27
Forum: Ask For Help
Topic: Filtering a period by date from inputbox AHK Topic is solved
Replies: 2
Views: 305

Filtering a period by date from inputbox AHK Topic is solved

Hi, i need help. I want Filtering a period by date from inputbox, example 01.05.2017-20.05.2018 This is VBA Dim X As Double, Y As Double X = Application.InputBox(Message, Title, Type:=1) Y = Application.InputBox(Message, Title, Type:=1) Cells(1, d).Resize(n).AutoFilter 1, ">=" & X, xlAnd, "<=" & Y
by inseption86
31 May 2018, 06:31
Forum: Ask For Help
Topic: How to remove a filter from a specific column Topic is solved
Replies: 5
Views: 404

Re: How to remove a filter from a specific column Topic is solved

Thank you very mach,
xl.ActiveSheet.Range("A2:AX2").AutoFilter(16) - work
by inseption86
31 May 2018, 05:42
Forum: Ask For Help
Topic: How to remove a filter from a specific column Topic is solved
Replies: 5
Views: 404

Re: How to remove a filter from a specific column Topic is solved

I want to delete a filter on one column, not everywhere
by inseption86
31 May 2018, 03:31
Forum: Ask For Help
Topic: How to remove a filter from a specific column Topic is solved
Replies: 5
Views: 404

How to remove a filter from a specific column Topic is solved

hi, please help. I have

Code: Select all

xl.ActiveSheet.Range("A2:AX2").AutoFilter(16, "xx")
xl.ActiveSheet.Range("A2:AX2").AutoFilter(16, "xxx"). Delete ?????????
....
xl.ActiveSheet.Range("A2:AX2").AutoFilter(17, "xxx")
.....
by inseption86
30 May 2018, 13:07
Forum: Ask For Help
Topic: How to count the number of rows when applying a filter Topic is solved
Replies: 2
Views: 331

How to count the number of rows when applying a filter Topic is solved

hi, Is it possible to find the number of lines after filtering?

Code: Select all

MsgBox,  % xl.Range("Q" xl.Rows.Count).End(xlUp := -4162).Row
This limits the total number
by inseption86
14 May 2018, 08:11
Forum: Ask For Help
Topic: FormatConditions com excel Topic is solved
Replies: 2
Views: 309

FormatConditions com excel Topic is solved

double:= Xl.Range("A:A") double.FormatConditions.AddUniqueValues double.FormatConditions.DupesUnique(1) := xlDuplicate double.FormatConditions(1).Font.Color := 16711680 Please help. Is not working. unique values ​​are displayed With macro working Sub sdsd() Range("A:A").Select Selection.FormatCondi...
by inseption86
20 Apr 2018, 06:11
Forum: Ask For Help
Topic: Copy result from IE to excel
Replies: 0
Views: 172

Copy result from IE to excel

Hello, sorry my english, i need ahk Copy result from IE to excel. Example https://ibb.co/hiBgWn SetWorkingDir %A_ScriptDir% ; Ensures a consistent starting directory. $^1:: Setkeydelay, 35 FileSelectFile, Path, 3, , Open Excel File, Excel File (*.xls; *.xlsx) if Path = ExitApp Xl := ComObjCreate("Ex...
by inseption86
19 Apr 2018, 07:21
Forum: Ask For Help
Topic: Copying from excel In IE and back
Replies: 0
Views: 195

Copying from excel In IE and back

Forgive me for my English, Hello, tell me whether it is possible to automate routine work, for example, there is xls, in column A with some rows of data, you need to copy one cell into chrome into a certain coordinate and copy the result back to xls in column B and also to all other cells. To make t...
by inseption86
19 Apr 2018, 04:37
Forum: Скрипты и библиотеки
Topic: Копирование из экселя в хром и обратно
Replies: 0
Views: 1988

Копирование из экселя в хром и обратно

Здравствуйте, подскажите пож-та возможно ли автоматизировать рутинную работу, например, имеется xls, в столбце А с некоторым количеством строк данные, их необходимо копировать по одной ячейки в хром в определенную координату и полученный результат скопировать обратно в xls в столбец Б и также ко все...
by inseption86
19 Apr 2018, 00:30
Forum: Scripts and Functions
Topic: Copying from excel In chrome and back
Replies: 1
Views: 407

Copying from excel In chrome and back

Forgive me for my English, Hello, tell me whether it is possible to automate routine work, for example, there is xls, in column A with some rows of data, you need to copy one cell into chrome into a certain coordinate and copy the result back to xls in column B and also to all other cells SetWorking...

Go to advanced search