Posted to microsoft.public.excel.programming

external usenet poster

Posts: 74

Selection Code

Consider the following:
Range(Cells(CurrentRow, 1), Cells(CurrentRow, 7)).Select
Selection.Locked = False
Selection.FormulaHidden = False
Cells(CurrentRow, 9).Select
Selection.Locked = False
Selection.FormulaHidden = False

Is there a way to combine the two select statements into just one?

Thanks,
Bernie

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
cell selection code	NDBC	Excel Discussion (Misc queries)	6	August 11th 09 06:39 AM
Help with selection code	Jeff[_45_]	Excel Programming	4	February 14th 05 04:37 PM
Cell selection code	ToddG	Excel Programming	2	September 22nd 04 09:26 PM
Need Code For Selection	SMILE	Excel Programming	3	August 10th 04 12:34 PM
Selection code	sixfivebeastman	Excel Programming	3	May 27th 04 08:54 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us