AND/OR/NOT-search

		Microsoft Office Forums > Microsoft Excel > Excel
AND/OR/NOT-search

FAQ

Thread Tools

Display Modes

09-09-2011, 02:59 AM

joblo108

Windows XP AND/OR/NOT-search

Office 2003

Novice

Join Date: Sep 2011

Posts: 2

Hi

I am trying to run the macro but I get a “runtime error no 9: the index is outside of interval”. I’m a newb when it comes to MS Excel and programming. The problem is in the line

MyKeys = Sheets("Keywords").Range("A2:A" & Sheets("Keywords").Cells(Rows.Count, 1).End(xlUp).Row)

of the macro.

How should I change it to conform with my spreadsheet?

Thanks for your help!

/Johan

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Search Function	Rick203	Outlook	1	08-29-2011 11:23 PM
Instant Search's "Display search results as I type when possible" with Exchange	lwc	Outlook	0	06-01-2011 01:56 AM
Search for an attachment	Pryach	Outlook	0	06-15-2010 09:36 AM
Search and Replace - Clear Search box	JostClan	Word	1	05-04-2010 08:46 PM
Wildcard search help.	Kempston	Word	0	11-13-2009 03:58 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:25 AM.