View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
erikkeith via OfficeKB.com erikkeith via OfficeKB.com is offline
external usenet poster
 
Posts: 31
Default Need help with setting variables

I want to set variables so I can use them in the following way:

A = James
B = Ron
C = Tony

Range("M33").Select
If Range("AB22").Value = "N" Then
ActiveCell = "A"
Else: ActiveCell = "Alternate"
End If

What syntax to I use to make this run in VBA?

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