Re: $$Excel-Macros$$ How to get the system name using macro

2011-01-06 Thread lawrence hordy
is this how you name your computer ? On Thu, Jan 6, 2011 at 3:47 PM, Daniel wrote: > Hi, > > MsgBox Environ("computername") > > Regards. > > Daniel > > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > De > la part de Rajesh K R > Envoyé :

Re: $$Excel-Macros$$ For Separate words from Capital letters

2010-08-11 Thread lawrence hordy
a dedicated "search" you have 72 names to search for if then else 72 "if thens" and iterate your loops for next one to 72 On Wed, Aug 11, 2010 at 8:41 AM, Raj Kumar wrote: > Hi, > > This is a attachment. I want to separate words on the base of Capital > Letter so kind suggest me that how can we

Re: $$Excel-Macros$$ Making sheet references dynamic

2010-07-26 Thread lawrence hordy
try thinking like music pages of sheetsor sheets of pagesthere will be timing loops On Mon, Jul 26, 2010 at 5:26 PM, Edgar wrote: > Hi Everyone, > > Does anyone know how to make sheet references in an equation dynamic. > Specifically, I want to list the names of a series of sheets in