Search found 402 matches

by Sabestian Caine
19 Aug 2016, 12:40
Forum: Ask For Help
Topic: How to select a cell of a specific data range (column) which contains any value in MS Excel?
Replies: 2
Views: 499

How to select a cell of a specific data range (column) which contains any value in MS Excel?

Dear ahk gurus first of all I appreciate your skills and zeal of helping newbies like me. Friends I want that when I press f1 key then it should select that cell of a specific data range (column) which contains any value i.e. which is not blank. For example I have a range say A1:A40 and there are va...
by Sabestian Caine
19 Aug 2016, 12:26
Forum: Ask For Help
Topic: How to search any four digit value in a specific column in ms Excel?
Replies: 3
Views: 383

Re: How to search any four digit value in a specific column in ms Excel?

Read up on Excel COM Controls. A google search will give you a few articles. You'll want to loop through column Q until you get a blank cell. Every cell should be checked for string length and the 4 digit cells can be stored with thier cell reference in an array. From there you can jump around the ...
by Sabestian Caine
18 Aug 2016, 13:01
Forum: Ask For Help
Topic: How to search any four digit value in a specific column in ms Excel?
Replies: 3
Views: 383

Re: How to search any four digit value in a specific column in ms Excel?

Dear friends I am posting here snap shoot of excel sheet which will clear my question more efficiently-

http://tinypic.com/view.php?pic=106mxlj&s=9

Please provide me a solution of this problem....i will be highly obliged to you....thanks....
by Sabestian Caine
18 Aug 2016, 12:26
Forum: Ask For Help
Topic: How to select specific cell when specific sheet of specific workbook is activated in MS Excel?
Replies: 13
Views: 1017

Re: How to select specific cell when specific sheet of specific workbook is activated in MS Excel?

Thanks punchin. For future reference, the "Description" line in the error message is usually helpful. It's the first place I look. Also, it was omitted it from the error message quoted above, but the full error message will show the line on which it occurred. Note that it specifically highlights li...
by Sabestian Caine
18 Aug 2016, 12:25
Forum: Ask For Help
Topic: How to select specific cell when specific sheet of specific workbook is activated in MS Excel?
Replies: 13
Views: 1017

Re: How to select specific cell when specific sheet of specific workbook is activated in MS Excel?

punchin wrote:Nice catch, guest. The comparator got changed to assignment operator. That would definitely cause issues.
Thanks dear punching.....
thanks a lot.....
by Sabestian Caine
17 Aug 2016, 06:09
Forum: Ask For Help
Topic: How to search any four digit value in a specific column in ms Excel?
Replies: 3
Views: 383

How to search any four digit value in a specific column in ms Excel?

Friends I want that when I press f1 key then it should start a search of any four digit value in column Q. moreover the search should start from the bottom of the column Q. For example I have 2541, 25836, 145, 5236, 48256525 and 3654 values in cell no Q8, Q12, Q25, Q30, Q39 and Q48 respectively. Loo...
by Sabestian Caine
17 Aug 2016, 00:10
Forum: Ask For Help
Topic: How to select specific cell when specific sheet of specific workbook is activated in MS Excel?
Replies: 13
Views: 1017

Re: How to select specific cell when specific sheet of specific workbook is activated in MS Excel?

If (xl.ActiveSheet.Name = "Sheet2") xl.Range("N2").Select Else Send, ^f Dear punchin the codes suggested by you are working fine- #IfWinActive Microsoft Excel - cash sheet act and amt.xlsm f1:: xl:=ComObjActive("Excel.Application") if (xl.Activesheet.Name:= "sheet2") xl.range("n2").select else send...
by Sabestian Caine
16 Aug 2016, 03:05
Forum: Ask For Help
Topic: How to select specific cell when specific sheet of specific workbook is activated in MS Excel?
Replies: 13
Views: 1017

Re: How to select specific cell when specific sheet of specific workbook is activated in MS Excel?

@Sabestian Caine I suggest reading more about how if works since that has been a problem for you twice now. Notice that the code I wrote used MsgBox not if . It showed the text "Sheet2" in the message box. So, xl.ActiveSheet.Name produces the text "Sheet2", that means that writing if xl.ActiveSheet...
by Sabestian Caine
16 Aug 2016, 03:04
Forum: Ask For Help
Topic: How to select specific cell when specific sheet of specific workbook is activated in MS Excel?
Replies: 13
Views: 1017

Re: How to select specific cell when specific sheet of specific workbook is activated in MS Excel?

punchin wrote:

Code: Select all

If (xl.ActiveSheet.Name = "Sheet2")
    xl.Range("N2").Select
Else
    Send, ^f
Thanks dear punchin.......now the codes are working fine.....i appreciate your skills in ahk.....thanks a lot once again....
by Sabestian Caine
14 Aug 2016, 13:16
Forum: Ask For Help
Topic: How to open google chrome window using com object module?
Replies: 2
Views: 983

Re: How to open google chrome window using com object module?

Guest wrote:Chrome does not have a COM interface.
thanks Guest for your good answer....
I appreciate you....
Could you please tell any alternative of Com interface in google chrome.....
thanks....
by Sabestian Caine
14 Aug 2016, 13:06
Forum: Ask For Help
Topic: How to select specific cell when specific sheet of specific workbook is activated in MS Excel?
Replies: 13
Views: 1017

Re: How to select specific cell when specific sheet of specific workbook is activated in MS Excel?

if xl.sheets("sheet2").select This is wrong. This selects sheet 2. It does not tell you what sheet is selected. send {ctrldown}f{ctrlup} This is wrong. See the docs for Send. It should be {ctrl down} . Of course, usually just doing this works: Send, ^f Try this: MsgBox, % xl.ActiveSheet.Name Dear G...
by Sabestian Caine
14 Aug 2016, 02:44
Forum: Ask For Help
Topic: How to open google chrome window using com object module?
Replies: 2
Views: 983

How to open google chrome window using com object module?

friends i want to use com object module to open google chrome window. for this i tried to use these basic codes- f1:: gc:=comobjcreate("googlechrome.application") gc.Visible := True return when i run the codes it shows the error massage saying "Error 0x800401F3 - Invalid class string". However when ...
by Sabestian Caine
14 Aug 2016, 02:20
Forum: Ask For Help
Topic: How to remove specific values from clipboard?
Replies: 14
Views: 1968

Re: How to remove specific values from clipboard?

F1:: Clipboard := Trim(RegExReplace(Clipboard, "m)^(\d\d-\d\d-\d\d)$|^(D[^\d]?\d*)$", ""), " `r`n`t") ; This will work even if the dates change. Return Thanks dear Shadowpheonix the codes suggested by you are working as i want exactly ....you are really great at ahk.....i appreciate your skills and...
by Sabestian Caine
14 Aug 2016, 01:57
Forum: Ask For Help
Topic: How to select specific cell when specific sheet of specific workbook is activated in MS Excel?
Replies: 13
Views: 1017

How to select specific cell when specific sheet of specific workbook is activated in MS Excel?

Friends i want that when sheet2 of specific workbook (Microsoft Excel - cash sheet act and amt.xlsm) is activated then it should select cell no n2 when i press f1 key. In other words when Microsoft Excel - cash sheet act and amt.xlsm is activated and in the workbook Microsoft Excel - cash sheet act ...
by Sabestian Caine
12 Aug 2016, 02:35
Forum: Ask For Help
Topic: How to remove specific values from clipboard?
Replies: 14
Views: 1968

How to remove specific values from clipboard?

Friends I want that specific values should be removed from the copied data (clipboard). For example I have following data in clipboard- 12-08-16 12-08-16 12-08-16 12-08-16 DL10587 DL10575 DL11318 DL2514 DL8526 DL36521 DL7485 70,000.00 14,700.00 3,000.00 I want that when I press f1 key then all the d...
by Sabestian Caine
12 Aug 2016, 00:34
Forum: Ask For Help
Topic: How to select sheet2 if sheet1 is activated and sheet3 if sheet2 is activated in ms excel?
Replies: 15
Views: 1626

Re: How to select sheet2 if sheet1 is activated and sheet3 if sheet2 is activated in ms excel?

F12::NextSheet(ComObjActive("Excel.Application").ActiveWorkbook).Activate NextSheet(Wbk) { return Wbk.Worksheets(Wbk.Worksheets.Count = (Idx := Wbk.ActiveSheet.Index) ? 1 : Idx + 1) } :idea: :?: Thanks dear Guest for your kind help....codes suggested by you are working fine as i want.....thanks a l...
by Sabestian Caine
11 Aug 2016, 13:53
Forum: Ask For Help
Topic: How to select sheet2 if sheet1 is activated and sheet3 if sheet2 is activated in ms excel?
Replies: 15
Views: 1626

How to select sheet2 if sheet1 is activated and sheet3 if sheet2 is activated in ms excel?

friends i want that when i press f1 key then it should select sheet2 if currently sheet1 is selected, similarly it should select sheet3 if it is selected sheet2 currently, similarly if it is selected sheet3 currently then it should select sheet4. I mean to say is that it should select the next sheet...
by Sabestian Caine
09 Aug 2016, 12:47
Forum: Ask For Help
Topic: How to remove extra 'enter' while sending the content of a variable into ms excel sheet?
Replies: 7
Views: 736

Re: How to remove extra 'enter' while sending the content of a variable into ms excel sheet?

I want it should contain single enter (linefeed) so that the data can be sent in the continuous cells (without any blank cell among them). f1:: send {ctrldown}a{ctrlup} sleep 100 send {ctrldown}c{ctrlup} sleep 100 Loop, Parse, Clipboard, `n, `r { If (A_LoopField = ) continue var1 .= A_LoopField ? A...
by Sabestian Caine
09 Aug 2016, 06:21
Forum: Ask For Help
Topic: How to remove extra 'enter' while sending the content of a variable into ms excel sheet?
Replies: 7
Views: 736

Re: How to remove extra 'enter' while sending the content of a variable into ms excel sheet?

Sorry, stringreplace, var1, clipboard, `r`n, all should be stringreplace, var1, clipboard, `r`n, , all See also https://autohotkey.com/board/topic/115962-regex-to-remove-blank-lines/ thanks dear GEV once again for helping me....but sir stringreplace, var1, clipboard, `r`n, , all is removing even si...
by Sabestian Caine
09 Aug 2016, 05:20
Forum: Ask For Help
Topic: How to remove extra 'enter' while sending the content of a variable into ms excel sheet?
Replies: 7
Views: 736

Re: How to remove extra 'enter' while sending the content of a variable into ms excel sheet?

stringreplace, var1, clipboard, `r`n, all var1 := Trim(var1, "`r`n") Thanks dear GEV for your kind help....but the codes suggested by you are not working as i want....i used these codes after modification in codes but the result remained same as earlier- f1:: send {ctrldown}a{ctrlup} sleep 100 send...

Go to advanced search