Posted to microsoft.public.excel.programming

Jim Tibbetts Jim Tibbetts is offline

external usenet poster

Posts: 74

Go to cell based on formula result

Hi All - I have been playing with this and can't get it to work. I want to
move the cursor to the right based on the result of a formula in D8. Can
anybody steer me in the right direction?

Range("F1").Select
ActiveCell.Offset("0, " & Range("D8").Value).Select

Thanks
--
Jim T

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
Formula result based on Multiple IFs	Neil M	Excel Worksheet Functions	6	June 23rd 08 10:44 PM
VLOOKUP based on a formula result	ufo_pilot	Excel Worksheet Functions	1	May 29th 08 05:04 PM
Advanced formula - Return result & Show Cell Reference of result	Irv	Excel Worksheet Functions	7	May 6th 06 03:36 AM
Selection based result formula	siweltj	Excel Programming	3	October 13th 04 01:46 PM
Hiding cells based on formula result	Jim	Excel Programming	0	June 19th 04 02:52 PM

All times are GMT +1. The time now is 10:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us