Whats wrong with this line?

[ParanoidAndroid]

Hi Guys

Whats wrong with this line?

Sheets("Sheet1").Range("V1").value = "=H" & LastRowCounter "&P" & LastRowCounter

The problem appears to be with the " " around the '=H' and '&P'

 

[RSXchin]

You missed the '&' after 'LastRowCounte'

 

[Trebor76]

You're missing an ampersand, i.e.

Sheets("Sheet1").Range("V1").Value = _
        "=H" & LastRowCounter & "&P" & LastRowCounter

HTH

Robert

 

[ParanoidAndroid]

I want the it to be

H2&P2

with the 2 being a variable number dependent on the counter

 

[ParanoidAndroid]

Dim LastRowConter as Long

LastRowCounter = .Cells(Rows.Count, "G").End(xlUp).Row

 

[ParanoidAndroid]

Oh - I see...Yeh the &

Such a small thing...Annoying..

Thanks for you help guys