PDA

View Full Version : Solved: Using Mid Question



gibbo1715
10-13-2005, 04:30 AM
All

I am trying to use the code below to select a worksheet as follows

My Worksheet is named B and My String called Choice is "=B*"

I was trying the code below

Worksheets(Mid(Choice, 1, 2)).Cells.ClearContents

rng.SpecialCells(xlCellTypeVisible).EntireRow.Copy _
Worksheets(Mid(Choice, 1, 2)).Range("A1")

Can anyone tell me my error please

Thanks

Gibbo

gibbo1715
10-13-2005, 04:53 AM
Ok Silly mistake, works if i get my arguments the right way round Mid(Choice,2,1)

austenr
10-13-2005, 11:54 AM
Is this solved? If so please mark it as such. Thanks

malik641
10-13-2005, 12:59 PM
Hey austenr, did you get that memo on those TPS reports? :rofl:

austenr
10-13-2005, 01:01 PM
That movie is great!! So much of it is really true in a lot of organizations. Except for the part where Melvin burns down the place. I like the part where they program the virus and screw up the decimal points..

malik641
10-13-2005, 01:13 PM
That movie is great!! So much of it is really true in a lot of organizations.I know!! I practically live that movie since I came to my new job. Actually, one of the first weeks of working at my job somebody mentioned the "Mondays"...http://vbaexpress.com/forum/images/smilies/rotlaugh.gif ....I almost laughed in their face when they said that hahaha

Zack Barresse
10-13-2005, 03:07 PM
I LOVE THAT MOVIE!!! GOT IT ON DVD! :D

"Yeah .. and if you can have those TPS reports for me by the end of the day, that'd be great."

"Um ya. I'm gonna ask you to go ahead and come in on Saturday."

"Looks like somebody has a case of the Mondays!"