View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Carrie_Loos via OfficeKB.com Carrie_Loos via OfficeKB.com is offline
external usenet poster
 
Posts: 116
Default Stop the macro at the end of a certain column #2

Same problem skip right to End If

Dave Peterson wrote:
C.address is in A1 reference style.

You could check
if c.address = "$AU$65535"

Some nice person out there gave me the code " If c.Address = "R65535C47" Then
Exit For End If"

[quoted text clipped - 52 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200801/1



--
Message posted via http://www.officekb.com