Why wouldn't this line work?
It seems like it would work. Am I filling in the range parameter wrong?![]()
fRow = Application.WorksheetFunction.Match(Target, "A1:A300", 0)
Why wouldn't this line work?
It seems like it would work. Am I filling in the range parameter wrong?![]()
fRow = Application.WorksheetFunction.Match(Target, "A1:A300", 0)
Last edited by Leith Ross; 02-01-2013 at 12:59 PM.
Yes, try:
![]()
fRow = Application.WorksheetFunction.Match(Target, Range("A1:A300"), 0)
Hello ExcelWizards,
You are correct about the parameter being incorrect. In VBA all characters enclosed in double quotes are Strings. This works for defining the Range address but is not a Range object which the parameter wants.
Change your code to this...
![]()
fRow = Application.WorksheetFunction.Match(Target, Range("A1:A300"), 0)
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
thanks guys, marking as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks