Posted to microsoft.public.excel.programming

Wes_A[_2_] Wes_A[_2_] is offline

external usenet poster

Posts: 37

Code wont work - help please

My code:
Appears to run through but does not produced the expected result, only
offsets from current cell.

Sheets("AUDIT_TRAIL_MONTHLY").Select
On Error Resume Next
Range("A13:A24").Find(What:=Range("D2"), LookIn:=xlValues, _
LookAt:=xlWhole, SearchOrder:=xlByRows, _
SearchDirection:=xlNext, _
MatchCase:=False).Offset(0, 1).Activate

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
why is there a { in my formula and why wont it work?	Gorgsey	Excel Discussion (Misc queries)	6	March 19th 09 03:17 AM
Function wont work!?	Jonas	Excel Programming	1	March 6th 06 04:24 PM
Anyone know why this wont work?	Mark Stephens	Excel Programming	2	June 13th 05 06:08 AM
Conditional formatting code wont work	Robert Hargreaves[_2_]	Excel Programming	5	June 5th 05 08:40 PM
Why wont this code work?	Mark Stephens[_3_]	Excel Programming	1	April 30th 05 07:01 PM

All times are GMT +1. The time now is 12:08 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us