Prev: Return value from cell info
Next: Print Spreadsheet to PDF file with Excel 1997
From: Stefi on 15 Jan 2010 07:32
On Jan 14, 6:02 pm, "Rick Rothstein"
<rick.newsNO.S...(a)NO.SPAMverizon.net> wrote:
> Another way to count the asterisks (just so you can see that VB is rich with possibilities) is this...
>
> NumberOfAsterisk = UBound(Split(Range("C1"), "*"))
>
> --
> Rick (MVP - Excel)
>
>
>
> "michael.beckinsale" <michael.beckins...(a)ntlworld.com> wrote in messagenews:dcd931bd-b69f-4ddd-8c78-be069a6b6275(a)m3g2000yqf.googlegroups.com...
> > Hi Stef,
>
> > Thanks very much, works like a dream.
>
> > I would never thought of doing that way!
>
> > Regards
>
> > Michael- Hide quoted text -
>
> - Show quoted text -

That's really tricky!
Stefi
First  |  Prev  | 
Pages: 1 2
Prev: Return value from cell info
Next: Print Spreadsheet to PDF file with Excel 1997