Hi,

a small correction:

=INDIRECT(CHAR(COLUMN()*3+64)&34)

enter this formula in the cell A1 and then copy drag it to B, C, D, .....

Thanks,
--
Farhad Hodjat


"Don Guillett" wrote:

Or for row 34
=INDIRECT(CHAR(COLUMN(A1)*2+64)&34)
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Don Guillett" wrote in message
...
Try this idea copied to the right
=INDIRECT(CHAR(COLUMN(A1)*3+64)& ROW())

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Sasikiran" wrote in message
...
Hello,

I have a problem while dragging the formula to the next cells.

The formula in A1 of sheet 1 is ='Sheet2'!C34
The formula in B1 of sheet 1 is ='Sheet2'!F34
The formula in C1 of sheet 1 is ='Sheet2'!I34

Here while dragging the formula, the next cell has to take the value of
the
same row (34) of every third column C, F, I, L... so on. But while
dragging
its not coming the same way.

Can anyone suggest me how to do that?

Thanks in advance
Sasikiran