You've set a range (myRng1) to something, but you're referencing the entire
row of that range, but you want only one column of that row (which then
becomes a reference to one cell), but you want the cell one row below that
cell?? It seems kind of a round-a-bout way to point to a single cell. What
exactly are you trying to do? Post more code. There's got to be a simpler
way to do what you want.

"SteveDB1" wrote:

Hi all.
Hope everyone is having as great a day as I am.....Or better... 8-)
In one of my macros, I'm using:

myRng1.EntireRow.Columns(8).Offset(1, 0)

While it's working good, I've come to realize that with the columns(), I'd
like it to be where I choose it, and not specifically at column H.
There've been a few instances where I have data in H, and it does what I've
told it--in the code-- thus overwriting that data, and in reality, that's not
what I want.

So, my question, what would it take to generically place the initial data at
my location/column of choice?

Thank you.
Best.