A spreadsheet’s bottom right-hand corner (Excel 2000 and XP)

Topic

New Reply

Hi. It appears to me that all spreadsheets have a bottom right-hand corner. I can go there by keying Ctrl-End. However, if I delete a row from the middle of the spreadsheet then the bottom right-hand corner doesn’t change. It is still the same cell as before.

This matters quite a lot when uploading a spreadsheet into MS SQL Server using DTS. The upload proceeds to load every row up to and including the one that holds the bottom right-hand corner. Except that this row is now blank because I have deleted a row some way above it. My database table won’t allow nulls so the blank row causes the upload to abort.

Is there any way to force Excel into accepting a specified cell as the bottom right-hand corner?

Thanks in anticipation

Reply | Quote

Replies

See post 235417 for a response and some other links that might help

Steve

Reply | Quote

Hi Steve,
Many thanks for your link. I tried a search of previous threads without success. I guess you have to know the keywords. “Bottom right hand corner” was obviously not technical enough!

Anyway, I have just now had success with sending the cursor to A1, saving, closing the file and opening it again. This didn’t seem to work before, but maybe I wasn’t concentrating.

Reply | Quote

Hi John,
If you haven’t already tried it, then ASAP Utilities is a free add-in that includes macros to remove these unused rows and columns and reset Excel’s UsedRange accordingly.
Hope that helps.

Reply | Quote

Hi John,
If you haven’t already tried it, then ASAP Utilities is a free add-in that includes macros to remove these unused rows and columns and reset Excel’s UsedRange accordingly.
Hope that helps.

Reply | Quote

It is more than just going to A1, you have to delete the rows/columns that are unused to clear formatting. There is some code referenced in that post.

Steve

Reply | Quote

It is more than just going to A1, you have to delete the rows/columns that are unused to clear formatting. There is some code referenced in that post.

Steve

Reply | Quote

Hi Steve,
Many thanks for your link. I tried a search of previous threads without success. I guess you have to know the keywords. “Bottom right hand corner” was obviously not technical enough!

Anyway, I have just now had success with sending the cursor to A1, saving, closing the file and opening it again. This didn’t seem to work before, but maybe I wasn’t concentrating.

Reply | Quote

If I can throw in a thought from a different angle.
If its possible to control the uploading procedure, would it not be easier to modify the procedure to upload to the last row containing data, than to fuss around with blank rows at the bottom of the sheet!
Just a suggestion!

Reply | Quote

Hi Rudi,

Sadly, MS’s Import Export wizard (the utility that imports spreadsheets into SQL Server tables) gives you no control at all over the range of data.

Thanks anyway
John

Reply | Quote

Hi Rudi,

Sadly, MS’s Import Export wizard (the utility that imports spreadsheets into SQL Server tables) gives you no control at all over the range of data.

Thanks anyway
John

Reply | Quote

If I can throw in a thought from a different angle.
If its possible to control the uploading procedure, would it not be easier to modify the procedure to upload to the last row containing data, than to fuss around with blank rows at the bottom of the sheet!
Just a suggestion!

Reply | Quote