Need help on Address
 

I have had help on this, but I lack the understanding of address and it
applies here...


For i = 3 To 4
lastcol = .Cells(40, Columns.Count).End(xlToLeft)(1, 2).Column
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
With .Range(.Cells(40, lastcol), .Cells(LastRow, lastcol))
.Formula = "=IF(INDEX(MAPActive!" & Column(i).Address &
iCol & ",MA

In this what is happening with " & Column(i).Address & iCol &" ??


If someone could point me to a good reference to this I would
appreciate it...the help doesn't help much..


Thanks,

Hans

Need help on Address
 

if i = 10 then

from the immediate window:
i = 10
? Activesheet.Columns(i).Address
$J:$J

column9i) without the s and some type of qualifier will just raise an error.

that whole line thing looks a little bit screwy to me, so maybe you need to
go back to your helper.

--
Regards,
Tom Ogilvy




" wrote:

I have had help on this, but I lack the understanding of address and it
applies here...


For i = 3 To 4
lastcol = .Cells(40, Columns.Count).End(xlToLeft)(1, 2).Column
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
With .Range(.Cells(40, lastcol), .Cells(LastRow, lastcol))
.Formula = "=IF(INDEX(MAPActive!" & Column(i).Address &
iCol & ",MA

In this what is happening with " & Column(i).Address & iCol &" ??


If someone could point me to a good reference to this I would
appreciate it...the help doesn't help much..


Thanks,

Hans

Need help on Address
 

Tom,

Thanks it sounds like I need to scratch this and re-think before I go
back to the person...
As a FYI, the section you helped me with that immediately follows this
section,

WORKS LIKE A CHARM!

Thanks,

Hans


Tom Ogilvy wrote:
if i = 10 then

from the immediate window:
i = 10
? Activesheet.Columns(i).Address
$J:$J

column9i) without the s and some type of qualifier will just raise an error.

that whole line thing looks a little bit screwy to me, so maybe you need to
go back to your helper.

--
Regards,
Tom Ogilvy




" wrote:

I have had help on this, but I lack the understanding of address and it
applies here...


For i = 3 To 4
lastcol = .Cells(40, Columns.Count).End(xlToLeft)(1, 2).Column
LastRow = .Cells(.Rows.Count, "A").End(xlUp).Row
With .Range(.Cells(40, lastcol), .Cells(LastRow, lastcol))
.Formula = "=IF(INDEX(MAPActive!" & Column(i).Address &
iCol & ",MA

In this what is happening with " & Column(i).Address & iCol &" ??


If someone could point me to a good reference to this I would
appreciate it...the help doesn't help much..


Thanks,

Hans