$$Excel-Macros$$ Stack error problem

2008-09-09 Thread laurence . thayer
My apologies for posting code. What it should do is list how much to produce for a given demand over a period. When I try to run this I get a message about being out of stack space (28). EIC and PC are functions. If anyone has a clue on why I am triggering the stack error, please let me know. Than

$$Excel-Macros$$ Re: Function Trouble: Not sure how to correctly reference my variable

2008-09-09 Thread Deepa
Hi The tier values have to be refered as Tier1 = range("h743").value this will get the value contained in that particular cell you can also do range("H743").select activecell.value On Sep 8, 2:57 pm, XpandeR <[EMAIL PROTECTED]> wrote: > Hi Jim, > > you have to use the Val function as it returns t

$$Excel-Macros$$ alignment of the content

2008-09-09 Thread Ashish Khandelwal
Hi, What is the shortcut to left align or center align or right align of the contents in a cell. Ashish. --~--~-~--~~~---~--~~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@g

$$Excel-Macros$$ Re: Validation

2008-09-09 Thread sajays
just reverse the formula. or xplain little more pls On Sep 6, 1:54 pm, "Ajay Varshney" <[EMAIL PROTECTED]> wrote: > What is the problem? What do you actually want to know? > > There is a formula in column F : =IF(E17<>"","You Cant Left the Cell > Blank","")  this formula means if cell in column E

$$Excel-Macros$$ request

2008-09-09 Thread ankur
dear members, i had my company logo ,which i want to paste on every page of excel when i take out print. at present i have to paste it again & again on all sheets..is there any method so that excel sheet take that logo as default it will help me a lot ,so that my MIS looks professiona