Thread: Compare value in cell A to value in Cell b and add 1
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kerry Kerry is offline
external usenet poster
  
Posts: 72
Default Compare value in cell A to value in Cell b and add 1
Hi,
When I run a VBA program in excel 2003 I want to compare the value in cell
B4 to the value in C3. If B4 < C3 then add 1 to B4 if not continue until
B4=C3 then reset to 1.
If B4<C3+1 else "1"
How do I write this in VBA?

Thankyou
--
Kerry
Reply With QuoteReply With Quote