Proper Syntax for Range Item.Offset needed please

[DougStroud]

I am trying an alternative method to place a value in the last used row offset 2 columns.
The first statement here works:

Cells(Rows.Count, 1).End(xlUp).Offset(, 2).Value = "Last-Item"

But I am trying to use a variable to locate the last used cell in col. A then offset it by two columns and place the value in that cell, which currently is C93.
This one fails, LI finds the last used row fine, but then the Range method fails. I tried using Cells.(LI but that failed too.

LI = Cells(Rows.Count, 1).End(xlUp) '.Offset(, 2)
  Range(LI, 1).Offset(, 2).Value = "Last-Item

"

Thanks--

Doug

 

[jindon]

Doug

You seem to be confusing useing "Range" and "Cells"

change 2nd line to

Cells(LI, 1).Offset(,2).Value = "Last-Item"

or either

Range("c" & LI).Value = "Last-Item"
Cells(LI, 3).Value = "Last-Item"

 

[DougStroud]

Thanks Jindon,
I thought it was going to be Cells, but when that failed I was pondering that maybe ti was returning a range item....
But where my real problem was that I did not qualify an object, you used .Value, I omitted this.
What I was looking for was .Row- which is interesting because in this line
LI=cells(rows.count,1).end(xlup) returns a last used row value of 93
but
LI=cells(rows.count,1).end(xlup).row returns a last used row value of 104
104 is actually the correct value.
I cannot figure out why the first line returned a different value.
Is there a way to plug this into the Immediate Window to test like you showed me last night. "Sorry- not good w/ the debugging tools yet.. but trying"

thanks for all the contined help

 

[jindon]

Doug

.Value is a default property of Rang/Cells, so if you omit property, it altomatically assumes as .Value.

If you see my codes, I never omit .Value, that's because I don't want to end up with unexpected result.

 

[DougStroud]

J-
I did not omit it on purpose, but an error.
But you just taught me something interesting-
What ever value is placed in the last used range, and the object is omitted then the variable takes on that value.
That is why LI had a value of 93 when .Row was left off, because 93 is the last value in the last used cell in col. A
It was just a fluke that I had a numerical value there and that gave me a clue when you said that .value is the defalut of range/cells.
Had it been a text value I would not have discovered that.
ok.. again a late night so I am out of here.
I still want to go over your blazing fast loop, so maybe tomorrow night...

See you and thanks