Replies

Yes it is, thanks! I don’t have a clue why I didn’t see it earlier. I appreciate the help.

Rick

Thanks, guys! Now I have three ways to accomplish the task. I appreciate the help.
Happy Holidays, Rick

Thanks, guys! Now I have three ways to accomplish the task. I appreciate the help.
Happy Holidays, Rick

John, I don’t understand this answer. Are you saying to use a text box? I thought of that except this workbook is something HQ sent out for us to complete and return. They will then combine my response with others across the country into one file. I don’t think a textbox would work in this situation.

Balby and Dave: Thanks for your suggestions. I will check them out today.

Thanks, it worked! I used this code:

ActiveWorkbook.Names(“Database”).Delete
lastCol = ActiveSheet.Range(“a1”).End(xlToRight).Column
lastRow = ActiveSheet.Cells(16384, lastCol).EndxlUp).Row
ActiveSheet.Range(“a1”, ActiveSheet.Cells(lastRow, _ lastCol)).Select

This allows me to select my new range.

However, now I have an additional problem. Once I make the selection, I want to name it “database.” When I record a macro to name it database, it refers to the cell range: ActiveWorkbook.Names.Add Name:=”database”, RefersToR1C1:=”=dedb_in!R1C1:R580C9″

Then, when I run the macro the next time, it makes the same range (R1C1:R580C9) the “database”, rather than the selection I just made.

Is there some way to name the new selection “database” each time without having the cells from the previous database become the new database? For example, I tried:

ActiveWorkbook.Names.Add Name:=”database”, RefersToR1C1:= _
“=dedb_in!R1C1:(lastRow, lastCol)”

but it didn’t work (even though I didn’t get an error).

I’m pretty new to VBA, so any help is appreciated!