Posted to microsoft.public.excel.programming

external usenet poster

Posts: 577

code fails if graph is selected

This code fails if a graph on the same sheet is selected (clicking inside the
graph)

Columns("B:B").Select

If I unselect the graph (clicking ouside the graph) then code runs fine.

What can I put in the code to make sure the graphs are not selected?

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
My code fails	kirkm[_6_]	Excel Programming	3	February 22nd 07 08:44 AM
Code fails if ran more than once	Christy	Excel Programming	11	August 31st 05 06:57 PM
ComboBox fails when last item selected first	MBlake[_2_]	Excel Programming	2	July 28th 05 07:51 PM
Filter Copy/Paste Fails - Two Ranges Selected?	Craigm[_27_]	Excel Programming	4	July 15th 05 04:16 PM
Excel Fails when add-in is selected	Ron	Excel Worksheet Functions	0	March 14th 05 12:18 AM

All times are GMT +1. The time now is 03:47 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us