Thread: "Loop until" syntax question
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Fastbike[_5_] Fastbike[_5_] is offline
external usenet poster
  
Posts: 1
Default "Loop until" syntax question

Hi,
I am after help for the following:

Range("TotalCentralregion").Select ' Range is a single cell
Selection.Offset(1, 0).Select
Selection.Formula = "=(" & ActiveCell.Offset(0, -2).Address & "
/EastTotal)"

What I need to do is loop this formula down a column until it gets to a
single cell that has been named "TotalEastRegion". (Formula has to
include "TotaleastRegion).

Thanks for the help in advance.

Fastbike


--
Fastbike
------------------------------------------------------------------------
Fastbike's Profile: http://www.excelforum.com/member.php...o&userid=26701
View this thread: http://www.excelforum.com/showthread...hreadid=401530

Reply With QuoteReply With Quote