Excel 2010 spellcheck text in shapes within a range

Hi,

Can you have a look at the following document.

http://danielcurran.com/instructions/how-to-use-spell-check-in-an-excel-spreadsheet-or-workbook/

To auto select press Ctrl G and type in the range a1:M50 and click ok.
It will keep the different ranges so you don't have to type them in again.

Then F7 to spell check that selected range.

See http://office.microsoft.com/en-au/excel-help/select-specific-cells-or-ranges-HP001217037.aspx


This is a macro to do the same thing. I just recorded the actions listed above and it works fine if I mispell a word in the range and press Ctrl l.

Sub myspelling()
'
' myspelling Macro
'
' Keyboard Shortcut: Ctrl+l
'
    Application.Goto Reference:="R1C1:R50C13"
    Selection.CheckSpelling SpellLang:=3081
End Sub

See the following article about references to cells etc.

http://office.microsoft.com/en-au/excel-help/about-cell-and-range-references-HP005198323.aspx

I have assigned the macro to the blue box and it should work okay for you.

Hope that helps.

pjwallis
Fixed-with-Macro.xlsm

Hello pjwallis,
thanks for taking a look at this, I don't think that approach will isolate only text in shapes within a defined range. It works fine for text within cells tho.

pls see the attached,
tx,
biker9
Not-Fixed-with-Macro.xlsm

Sorry I miss understood what you needed. I'm mobile till thursday, will have another look when i get back home.
pjwallis

… deleted… replied to wrong thread.

Thank you once again Martin!
biker9

ps; do you offer consulting services?

You're welcome and I'm glad I was able to help. I'm sorry but I don't do consulting but I'm happy to answer any of your questions that I can.  

Marty - MVP 2009 to 2013

Thanks Martin,

I've posted a new question re: consulting, titled "Advice on how to move an Excel, VBA project forward?”

biker9