Posted to microsoft.public.excel.programming

Magoo

external usenet poster

Posts: 21

excel if Range a1a2

Does any one know how to do this using vba.

I would like to have an if statement that is similar to this.

If Range("C8") Range("C16") Then
ActiveSheet.Shapes("Oval 806").Select
Selection.ShapeRange.Line.Visible = False
End If

This will not work Please help...

Thanks

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
RANGE EXCEL copy cell that meets criteria in a range	confused	Excel Worksheet Functions	3	March 27th 08 01:41 PM
Excel Addin:Setting the range to the Excel.Range object range prop	Rp007	Excel Worksheet Functions	5	November 24th 06 04:30 PM
Excel 2000 VBA - Set Print Range in dynamic range	sub_pop[_5_]	Excel Programming	2	July 27th 04 08:01 PM
adding reference-to-range control to excel range	Nir Sfez	Excel Programming	1	March 2nd 04 06:11 PM
Range.Formula and Range question using Excel Automation	[email protected]	Excel Programming	0	September 19th 03 04:53 AM

All times are GMT +1. The time now is 05:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us