|Once again, I'll ask the same question:|
Where do you really want the string to be placed?
You said I would like the first row to contain the string "Location=NY"
A row is a series of cells from Column A extending all the way out to the last column in your spreadsheet.
If you want the first row to contain the string "Location=NY" then you are asking for this:
A B C D E...
Location=NY Location=NY Location=NY Location=NY Location=NY etc.
I do not really think that you want the row to contain the string. Maybe you want a specific cell in the Row to contain the string, but not the whole Row...or do you?
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.