Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    The Hague, Netherlands
    Posts
    125
    Thanks
    0
    Thanked 1 Time in 1 Post

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

    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

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: A spreadsheet's bottom right-hand corner (Excel 2000 and XP)

    See <post#=235417>post 235417</post#> for a response and some other links that might help

    Steve

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: A spreadsheet's bottom right-hand corner (Excel 2000 and XP)

    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!
    Regards,
    Rudi

  4. #4
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    The Hague, Netherlands
    Posts
    125
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: A spreadsheet's bottom right-hand corner (Excel 2000 and XP)

    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

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    The Hague, Netherlands
    Posts
    125
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: A spreadsheet's bottom right-hand corner (Excel 2000 and XP)

    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.

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: A spreadsheet's bottom right-hand corner (Exce

    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.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: A spreadsheet's bottom right-hand corner (Excel 2000 and XP)

    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •