Spell check certain columns or range based on todays date

**yetibeard** · 06-14-2018, 06:45 PM

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!

**scottiex** · 06-14-2018, 07:09 PM

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.

**yetibeard** · 06-14-2018, 09:21 PM

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!

**scottiex** · 06-14-2018, 09:25 PM

Please Login or Register  to view this content.

**yetibeard** · 06-14-2018, 09:40 PM

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?

**scottiex** · 06-14-2018, 09:42 PM

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.

**yetibeard** · 06-14-2018, 09:47 PM

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

**yetibeard** · 06-14-2018, 09:50 PM

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

**scottiex** · 06-14-2018, 09:57 PM

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

**yetibeard** · 06-14-2018, 10:06 PM

Thank you very very much!!

Bravo

Spell check certain columns or range based on todays date

LinkBack

Thread Tools

Rate This Thread

Display

Spell check certain columns or range based on todays date

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

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

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

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

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

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

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

Adding a border from around a range based on todays date

Autohide Columns that are < todays date and > todays date by 2 & 7 days

Change the color of a range of cells based on date versus todays date

How to define chart range based on todays date

How to detect Spell Check activated - or - exit sub when you press cancel on Spell Check

Problem setting range in macro based on todays date.

Using VB to find a range based on todays date and todays date +30

Bookmarks

Bookmarks

Posting Permissions