Solved: Using Mid Question

[gibbo1715]

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]

Ok Silly mistake, works if i get my arguments the right way round Mid(Choice,2,1)

[austenr]

Is this solved? If so please mark it as such. Thanks

[malik641]

Hey austenr, did you get that memo on those TPS reports? :rofl:

[austenr]

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]

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]

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!"