Re: $$Excel-Macros$$ VBA Intersect Range...

2015-01-21 Thread Vaibhav Joshi
This code is not complete, do check & report.. ᐧ On Thu, Jan 22, 2015 at 11:20 AM, sswcharlie wrote: > Hi > > Excel2000 > > On code below I get a 'syntax' error. On row- Intersect. Code > off the net. Have tried some things but no luck. What have I missed ? > > Option Explicit > Pri

$$Excel-Macros$$ VBA Intersect Range...

2015-01-21 Thread sswcharlie
Hi Excel2000 On code below I get a 'syntax' error. On row- Intersect. Code off the net. Have tried some things but no luck. What have I missed ? Option Explicit Private Sub CommandButton1-Click() Dim Range As Integer Dim UsedRange As Integer Sheets("RegionalAreas").Select Intersect