View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Looping on Cells with $x$y

In itself a cell is not absolute ($B$1) or relative (B1), or any combination
thereof. It can contain a formula or a function that uses one of those modes
of addressing, but it could even contain more than one mode, or even all 4.

What specifically are you trying to do?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"D.Parker" wrote in message
...
Hello. I would like to utilize your expertise again. Is there a way to

to
loop through cells that have the form "$B$2", such as "$Bi$j", where i and

j
are integers. Is this possible? Is so how, because I tried with i and j

type
looping. Thanks again.

D. Parker