Did you rerun the macro after you typed in the new addresses?


CBrausa wrote:

What could be wrong that cells I52,I53,I54,I55,I56,I58 are skipped when
tabbing and entering the mandatory cells?
I have retyped, recopied,

Option Explicit
Sub testme()
With Worksheets("Product Quote") '<---
Range("T4,E5,M5,T7,E8,M8,d14,M14,D16,M16,D18,M18,m 19,M20,m21,U21,N23,b25,K29,B30,L31,B33,I33,B35,B39 ,B43,B45,F47,K47,P47,S47,V47,Y47,B49,I52,I53,I54,I 55,I56,I58,Q50,S55,S56,S57").Name
_
= "'" & .Name & "'!MustFill"
End With
End Sub

I even tried adding "&"

Option Explicit
Sub testme()
With Worksheets("Product Quote") '<---
Range("T4,E5,M5,T7,E8,M8,d14,M14,D16,M16,D18,M18,m 19,M20,m21,U21,N23,b25,K29,B30,L31,B33,I33,B35,B39 ,B43,B45,F47,K47,P47,S47,V47,Y47,B49,"
& "I52,I53,I54,I55,I56,I58," & "Q50,S55,S56,S57").Name _
= "'" & .Name & "'!MustFill"
End With
End Sub

Those 6 cells are driving me nuts.
Any suggestions?

--
CBrausa
------------------------------------------------------------------------
CBrausa's Profile: http://www.excelforum.com/member.php...o&userid=24677
View this thread: http://www.excelforum.com/showthread...hreadid=543367

--

Dave Peterson