View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
DaveO DaveO is offline
external usenet poster
 
Posts: 94
Default Sheet Rename (day 2)

HTH.

I would suggest somekind of validation in your code to make sure that
Range("B2") is both populated and does not use any special characters, like
Bob P refers to.

Only an idea.

"Darin Kramer" wrote:



Thanks - I had the .value in, but dropped it for somereason at a later
stage. Re-inserting it works perfectly :)

*** Sent via Developersdex http://www.developersdex.com ***