Rowliner does not work in conjunction with a search macro

June 19, 2012 at 04:46:39
Specs: Windows XP
Rowliner is fine moving around worksheet with the keyboard functions. Running a search macro the cursor default to "top" cell range as specified in the macro. E.g macro range would read- Range ("D10:D300").Select. Selecting data in cell d50 the cursor default to cell d10

See More: Rowliner does not work in conjunction with a search macro

Report •

June 19, 2012 at 12:27:42
I don't use the Rowliner Add-in so I can't address your problem specifically, however...

Why are you using Range ("D10:D300").Select?

Rarely, if ever, do you have to Select a Range in VBA in order to perform an action on it.

Since all that you posted was that single line, I can't offer any suggestions since I don't know what you are doing after you Select the range.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

June 20, 2012 at 01:48:47
Thx for reply: Let me explain: I have written a VBA code which display a Input box on top of a spreadsheet to search and select a specific account number of about 300 account numbers in the spreadsheet, in this case the account numbers appear in column "d", therefore is the range specified in the code only for column "d". Here is the code:

Private Sub CommandButton3_Click()

'Opens box and ask what do they want to search
searchthis = InputBox("Type in JDK number.", "Property Search")
'Tells where to search
'and then search in them whatever the user entered:
Selection.Find(What:=searchthis, After:=ActiveCell, LookIn:= _
xlFormulas, LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:= _
'if found go to first found
'if not found show message box saying it cannot be found

End Sub

When using the "Rowliner" add in with this code, the cursor default the 1st cell of column "d" iso to the number in a cell as selected in the Input Box

Hope this clarify the problem

Report •

Related Solutions

Ask Question