New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

New worksheet selection using "text" in cell on active sheet

Macros, VBA, Excel Automation, etc.

Re: New worksheet selection using "text" in cell on active sheet

Postby Lazmail » Thu Feb 05, 2015 2:25 am

Hi No Sparks,
Just one little "Space"
You were right I have just found that there was "an extra space" in the format for the cell (L1)
I have removed the little sucker and all is now O.K. with your macro and consequently mine are working perfectly.
I will now be able to carry on with the remaining design involved in producing the financial package for my Men's Shed Treasurer.
I would like to thank you very much and so will my Shed members when I let hem know at the next Committee Meeting.

I am very impressed with the Forum and as it is my very first time using this type of service I must apologise to anyone who I have offended by putting my problem on the incorrect Forum page.

Thank you once again No Sparks
Until next time
Cheers Lazmail
  • 0

Lazmail
Rookie
 
Posts: 14
Joined: Feb 3, 2015
Reputation: 0
Excel Version: 2007

Re: New worksheet selection using "text" in cell on active sheet

Postby NoSparks » Thu Feb 05, 2015 11:03 am

No problem Lazmail, at some point in time everybody was new to these kinds of forums. I'm sure no one was offended by anything. Don't take pecoflyer's post the wrong way it was only to let you know how to post code and bring the VBA subforum to your attention.

If that's the biggest mistake you ever make.... you got it made. :D

Pleased I was able to assist. Come back anytime.
  • 0

NoSparks
Excel Hobbyist
 
Posts: 637
Joined: May 28, 2014
Reputation: 103
Excel Version: 2010

Re: New worksheet selection using "text" in cell on active sheet

Postby pecoflyer » Thu Mar 24, 2016 2:35 am

Hello Lazmall,
by posting new questions in one of your existing threads, you are depriving members from the solution, because the question still appears under a thread title that might they not be interested in. ( fi the last answer from NoSparks is a non-VBA one that might interest members who don't use VBA often ( or ever))

When a problem is solved, it is best to start a new thread ( eventually with a link to a previous one), with a new and descriptive title.

I split this topic accordingly.

Don't hesitate to post any questions you have :)
Thank you
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010

Previous

Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 16 guests

cron