+ Reply to Thread
Results 1 to 10 of 10

Spell check certain columns or range based on todays date

  1. #1
    Registered User
    Join Date
    06-13-2018
    Location
    Cumbria, England
    MS-Off Ver
    2010
    Posts
    16

    Spell check certain columns or range based on todays date

    Hi,

    I'm brand new to VBA so bare with me!

    I have a protected sheet that i would like to spell check. The sheet is data and comments in columns under dates and is completes every day.

    What i would like is a spell check button which checks the last 5 columns of data. (or check today's date columns and the last 4 days)

    Is this possible? I know you can set up a spell check but I don't know about configuring it around a date.

    Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 2010
    Posts
    991

    Re: Spell check certain columns or range based on todays date

    try this
    if you have a password obviously you can add it to that first line. like "ActiveSheet.Protect "The Password", UserInterfaceOnly:=True"

    Please Login or Register  to view this content.
    Last edited by scottiex; 06-14-2018 at 07:12 PM.
    If you want something done right... find a forum and ask an online expert.

    Time flies like an arrow. Fruit flies like a banana.

  3. #3
    Registered User
    Join Date
    06-13-2018
    Location
    Cumbria, England
    MS-Off Ver
    2010
    Posts
    16

    Re: Spell check certain columns or range based on todays date

    Thanks for the reply, I'll try that when I get time.

    Would you mind explaining what this is doing please? I'm not used to code!

  4. #4
    Valued Forum Contributor
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 2010
    Posts
    991

    Re: Spell check certain columns or range based on todays date

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    06-13-2018
    Location
    Cumbria, England
    MS-Off Ver
    2010
    Posts
    16

    Re: Spell check certain columns or range based on todays date

    This didn't work and I think I know why.

    I have the dates already pre-populated, so the macro will always find December 31st. I tried typing in the end 5 dates and it worked for them.

    Is there any way for the spell check to work from a dated based in a cell on a different sheet?

  6. #6
    Valued Forum Contributor
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 2010
    Posts
    991

    Re: Spell check certain columns or range based on todays date

    I think you need to upload a sample because the exact location and format of the dates matters.

    or maybe you can just replace the * with the date that you want to find.
    Last edited by scottiex; 06-14-2018 at 09:45 PM.

  7. #7
    Registered User
    Join Date
    06-13-2018
    Location
    Cumbria, England
    MS-Off Ver
    2010
    Posts
    16

    Re: Spell check certain columns or range based on todays date

    I dont have the file just now, can I replace the * with a cell reference i.e 'sheet1'!A1

  8. #8
    Registered User
    Join Date
    06-13-2018
    Location
    Cumbria, England
    MS-Off Ver
    2010
    Posts
    16

    Re: Spell check certain columns or range based on todays date

    or can it look across a particular row rather than the full sheet for the last column?

  9. #9
    Valued Forum Contributor
    Join Date
    04-01-2013
    Location
    East Auckland
    MS-Off Ver
    Excel 2010
    Posts
    991

    Re: Spell check certain columns or range based on todays date

    Yes use either of the two options.

    1) format it like this

    Please Login or Register  to view this content.
    2) yes replace the lastcol row with this

    Please Login or Register  to view this content.
    replace 1 with whatever row you want to use

  10. #10
    Registered User
    Join Date
    06-13-2018
    Location
    Cumbria, England
    MS-Off Ver
    2010
    Posts
    16

    Re: Spell check certain columns or range based on todays date

    Thank you very very much!!

    Bravo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1