Hi everyone, in VBA, how would I write this: "If the
last 5 characters of A1 is "Total" then do
so-and-so"
Something like,
If [the last 5 characters of] Range("A1").Text =
"Total" Then
code here
Else: End If
Thanks for your help!
Crystal Khan
Oklahoma City
------------------------------------------------------------
--------------
The EXCEL-G list is hosted on a Windows NT(TM) machine
running L-Soft
international's LISTSERV(R) software. For
subscription/signoff info
and archives, see htt
p://peach.ease.lsoft.com/archives/excel-g.html .
COPYRIGHT INFO:
http://peach.ease.lsoft.com/scripts/wa
.exe?SHOWTPL=COPYRIGHT&L=EXCEL-G
|