goobers
03-31-2010, 10:22 AM
Hi everybody. I'm having a frustrating time with my latest project, but I know the answer is probably a lot simpler than I am trying to make it.
In the file I have uploaded, I want to be able to:
1) Identify the Last Column that contains Data, but only for the range starting with Row 9.
2) I then want to Copy the info from the last column with data (in my spreadsheet, that would be $D9:$D65536) into the next column to the Right (data would be copied into E9)
I have found plenty of VBA expressions that will identify the last row or last column, but for the life of me I can't find the code to search only for a specific range.
As always, thanks for all your help.
In the file I have uploaded, I want to be able to:
1) Identify the Last Column that contains Data, but only for the range starting with Row 9.
2) I then want to Copy the info from the last column with data (in my spreadsheet, that would be $D9:$D65536) into the next column to the Right (data would be copied into E9)
I have found plenty of VBA expressions that will identify the last row or last column, but for the life of me I can't find the code to search only for a specific range.
As always, thanks for all your help.