$$Excel-Macros$$ Excel Formula using LOG

2016-08-23 Thread Joseph Carney
I understand that this may not pertain to VBA particularly, but I thought that I might ask. I have a spreadsheet that has 4 columns of numbers (simple numbers). A fifth column has the following equation in it: =(11.078+1.131*LOG(B2)+0.416*LOG(C2)-0.274*LOG(D2)-0.005*(E2)) I am having

$$Excel-Macros$$ RE: HOTLIST:::: USC - GC:::::Open to Relocate

2016-08-23 Thread Marketing Softsages
Hello Professionals, Greeting from *SoftSages LLC*. Hope you are doing great. Please find the Updated Hotlist of* “Softsages Technologies Inc”*. If you have any suitable C2C requirements for our consultants please let me know. Send me your job requirements at given marketers Email ID’s.

Re: $$Excel-Macros$$ Changing Region and Language Setting using VBA

2016-08-23 Thread Paul Schreiner
I really don't think you're going to be able to do that.It would be kind-of dangerous if you could. The Region and Language settings aren't "Microsoft Office" settings, but Windows Environment settings.That is to say, they apply to the entire Windows Environment, not to any specific application

$$Excel-Macros$$ Changing Region and Language Setting using VBA

2016-08-23 Thread Nitin Balodi
Hi, Can anyone help me understand how can we change Region and Language setting using VBA. I want to change *Format:* English (United States) to English (United Kingdom) and vice-versa. Thanks in advance. Regards, Nitin Balodi -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you

$$Excel-Macros$$ RE: HOTLIST:::: USC - GC:::::Open to Relocate

2016-08-23 Thread Marketing Softsages
Hello Professionals, Greeting from *SoftSages LLC*. Hope you are doing great. Please find the Updated Hotlist of* “Softsages Technologies Inc”*. If you have any suitable C2C requirements for our consultants please let me know. Send me your job requirements at given marketers Email ID’s.

Re: $$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names

2016-08-23 Thread Pravin Gunjal
Hi Gaurav Checked once again and it's working fine. Thanks :) Need one more help with the same subject. In "Tab-Names" sheet, can we insert B1 cell of all the sheets along with sheet names in a column. *With regards,**Pravin Gunjal* *Mobile: 77100 * *97250* On Tue, Aug 23, 2016 at 4:27 PM,

Re: $$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names

2016-08-23 Thread Gaurav Devrani
What do you mean by 49 sheets. I don't think this code have such functionality not to work more than 49 sheets. I am sure you are confused with the code written inside. but still let me know your opinion about 49 sheets. On Tue, Aug 23, 2016 at 3:04 AM, Pravin Gunjal wrote: >

Fwd: $$Excel-Macros$$ Lock some cell for edit with option to copy raw & paste - Waiting for reply

2016-08-23 Thread big smile
-- Forwarded message -- From: big smile Date: 20 August 2016 at 12:00 Subject: $$Excel-Macros$$ Lock some cell for edit with option to copy raw & paste - Waiting for reply To: excel-macros@googlegroups.com Paul sir -- waiting for your reply. & no body

Re: $$Excel-Macros$$ Rename all sheets of one excel file in single shot with different names

2016-08-23 Thread Pravin Gunjal
Dear Gaurav Thanks for solution. You have created a sheet viz. *Tab-Names *and then used two macros based on requirement. But my worry is that in every month number of sheets are getting changed and I believe the codes can run only up to 49 sheets. Please check and advise. *With