VBA related to Excel - Cell range selections

[Jason S]

Hi, this is really a VBA question relating to EXCEL rather than Word, but I
couldn't find a good newsgroup for Excel VBA. But I'm sure VBA in Word and
Excel are identical, if not very similar.

Does anyone know some VBA code to simply check whether ot not a certain
range (e.g. A1:A6) of cells are currently SELECTED?

I need the code to be able to tell if certain cells on a spreadsheet are
selected or not. It should provide a True or False result.

Thanks,
Jason.

 

[Chuck]

Check out the .Address property in Excel VBE, then work with the Selection.
For instance, you can determine whether the selection address matches your
criteria, if so then do something, if not do something else. Note that
..Address has various optional parameters.

Dim strAddress As String

strAddress = "$F$2:$F$3"

If Selection.Address = strAddress Then
MsgBox "hi"
End If

 

[Helmut Weber]

Hi Jason,

If ActiveWindow.RangeSelection.Address = "$A$1" Then
MsgBox "true"
End If

But i'm sure there is better help in
microsoft.public.excel.programming
and
ExcelVBA and WordVBA are quite different, IMHO,
unless you think Word and Excel are very similar.

Greetings from Bavaria, Germany
Helmut Weber, MVP
"red.sys" & chr(64) & "t-online.de"
Word 2002, Windows 2000
Keep your VBA code safe,
sign the ClassicVB petition www.classicvb.org

 

[Jason S]

Beatutiful! Thanks very much guys. You solved my problem =o)
Have a great day/night!

Jason.

 

[Dennis]

Jason, argubably the "best" Excel news group for your question is:

http://support.microsoft.com/newsgr...oc=NEWSGROUPLN&dg=microsoft.public.excel.misc

It probably has two or three time the volumn of any other Office newsgroup

Dennis

 

[Jason S]

Thanks Dennis, I'll keep that in mind for next time =)

Cheers,
Jason.