fluffynicesheep
Board Regular
- Joined
- Oct 27, 2009
- Messages
- 69
Hi,
I have a piece of code that inserts a row of data at the bottom of an existing range, and then what I'm after is for a spell check to take place on that new row.
At the moment, the code below works fine .... it spell checks all the visible columns in that particular range.
To make it work even better though, i would love to not spell check ALL visible columns in the row, but to only spell check certain columns in the row ... e.g. Column D, Column AB, Column DE etc.
These columns will always remain the same.
If you could let me know how to do this, that would be amazing!
I have a piece of code that inserts a row of data at the bottom of an existing range, and then what I'm after is for a spell check to take place on that new row.
At the moment, the code below works fine .... it spell checks all the visible columns in that particular range.
To make it work even better though, i would love to not spell check ALL visible columns in the row, but to only spell check certain columns in the row ... e.g. Column D, Column AB, Column DE etc.
These columns will always remain the same.
If you could let me know how to do this, that would be amazing!
VBA Code:
'Spellcheck final row
With Range(Cells(LastCell.Row + 1, 1), Cells(LastCell.Row + 1, 572))
.Select
Selection.SpecialCells(xlCellTypeVisible).Select
Application.CommandBars("Tools").Controls("Spelling...").Execute
