Re: $$Excel-Macros$$ Remove the Space

2010-09-28 Thread SUMIT VYAS
Dear, Please Select A Row Press Ctrl + F Alt + P Find What :- Space Key 5 To 10 Replace With :- Blank Click Replace All Please try it On 9/25/10, Jai wrote: > > Dear Groups Member, > > I want to Remove the Space, In Cloum C , Sheet Attach, Please Help me. > > Thanks for Advance. > > > -

Re: $$Excel-Macros$$ Fwd: कविता :- उस Expert का शुभ नाम है......पाण् डेय MR. दिलीप जी.

2010-09-28 Thread Jai Deo Tiwari
Awesome ! It's only brief introduction of pandey ji pandey ji is like BOOK(Big Ocean Of Knowledge) where all VBA developers meet like rivers. * Best Regard, * * *** *...@i Deo t...@ri* *Software Engineer* *(Radar Technologies) b...@dohi(UP) to b...@ng@lore-560038* ***

Re: $$Excel-Macros$$ VB 6 Command button with icon righttoleft property True

2010-09-28 Thread Santosh Vishwakarma
As said in below mail. I even tried to set it at run time, but i failed! ...Me.RightToLeft = True the image appears above the text in command button From: عمر To: excel-macros@googlegroups.com Sent: Tue, 28 September, 2010 11:11:54 PM Subject:

$$Excel-Macros$$ Need next number with a twist

2010-09-28 Thread None
Hi there.  I need some help finding the next number but there's a twist.  Attached is a file that shows what I need. There's a sheet titled "Transactions" where the data is continually added to and the order cannot be changed so sorting the data is out of the question.  The next sheet is calle

RE: $$Excel-Macros$$

2010-09-28 Thread Dave Bonallack
A further question: Do you want the date in Col B to enter only when the adjacent cell in Col A receives text for the first time, or any time the adjacent Col A cell is changed? Regards - Dave. Date: Tue, 28 Sep 2010 23:40:09 +0530 Subject: $$Excel-Macros$$ From: sunscel...@gmail.com To: e

RE: $$Excel-Macros$$

2010-09-28 Thread Dave Bonallack
Hi Ramkesh, This can be done with an event macro, but not, I think, with worksheet formulas and/or functions. Are you allowed to use macros in this workbook? Regards - Dave. Date: Tue, 28 Sep 2010 23:40:09 +0530 Subject: $$Excel-Macros$$ From: sunscel...@gmail.com To: excel-macros@googlegr

$$Excel-Macros$$ Visible Row Below Freeze Pane

2010-09-28 Thread stuartR
With the top row frozen and the sheet scrolled down so that the first visible row below row 1 is row 32. How would I prove row 32 is the first visible row through VBA If i then wanted to make row 50 the first visible row, how could it be done through VBA -- -

$$Excel-Macros$$ Re: vba excel understanding objects : worksheet

2010-09-28 Thread cyber 1000s
Hi, I didn't get yet that far with structures. It should be my next move as I am heading toward c++ and I strongly believe it will help to understand the concept of objects in many languages (it could be Oobasic, coming cloud computing macros and so on and as for now Excel vba). Lots of evening and

RE: $$Excel-Macros$$ VB 6 Command button with icon righttoleft property True

2010-09-28 Thread عمر
Private Sub UserForm_Initialize() Me.RightToLeft = True End Sub From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Anju Sent: Tuesday, September 28, 2010 7:28 PM To: excel-macros@googlegroups.com Cc: davebonall...@hotmail.com; Ashish Pahuja; ayush jain;

$$Excel-Macros$$

2010-09-28 Thread Ramkesh Maurya
Dear All, Xl Mania(s) I really appreciate this group for learning I have lrarnet a lot of tricks from this group which enabled me to come of with flying colours.Today i am posting my first query briefing in below lines--- 1- I fill some text in column A (say) 2- I want that the date of

$$Excel-Macros$$ VB 6 Command button with icon righttoleft property True

2010-09-28 Thread Anju
In visual basic When I try to set a form's Righttoleft property to true.. it remains false! I even tried to set it at run time, but i failed! What is going on?! i want my command button look like attached.. --

$$Excel-Macros$$ Excel Related Jobs

2010-09-28 Thread krishna mummina
Hello All, My name is krishna, Currently working as a Data Analyst based on Excel. So, I want to know the Other Areas where we can Get the Job. Basically I have 2 years of MNC Experience as a Data Analyst, and I am a Excel Advance User. I am looking to give a try in Deloite and Other Big daddy's.

$$Excel-Macros$$ Fwd: कविता :- उस Expe rt का शुभ नाम है......पाण्डे य MR. दिलीप जी.

2010-09-28 Thread ayush jain
Hi Dilip, You deserve this appreciation in the form of poem. we all love you and your solutions. KEEP IT UP. Hi Noorain, I think we have a great poet with us...Now I will bother you to write more poems(or chaalisa) for our excel enthusiasts.. :) Thank you for awesome poem for wonderful person. M

$$Excel-Macros$$ Re: SOS! Help! Loading another workbook in the current workbook - cells not updating!

2010-09-28 Thread LunaMoon
Anybody thanks? On Sep 27, 6:33 pm, LunaMoon wrote: > SOS! Help! Loading another workbook in the current workbook - cells > not updating! > > Hi all, > > Please help me. I have spent quite a few days on this but couldn't get > it work. > > On Excel file A.xls, I have 5 file names(Excel files) in

Re: $$Excel-Macros$$ Help >-----> VBA Project Unprotect Required -Urgent

2010-09-28 Thread Venkat
Hi Devi, Thank u so much Regards, Venkat On Tue, Sep 28, 2010 at 11:14 AM, STDEV(i) wrote: > your vbaproject is now UnLOCKED > > > > > > On Mon, Sep 27, 2010 at 8:03 PM, Venkatesan c wrote: > >> Dear All, >> >> Kindly help VBA Project Unprotect Required. >> >> Best Regards, >> * >> >> Venka

$$Excel-Macros$$ problem???

2010-09-28 Thread SAJID MEMON
From: sajidwi...@hotmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ problem??? Date: Sun, 26 Sep 2010 17:28:13 + Dear Group, I want to retrive column wise data from diffrerent excel files to a particular format file. I have linked and only a cell is linked. i

$$Excel-Macros$$ Re: Please Help

2010-09-28 Thread anandydr
The solution would need a simple macro. using Button_Click event this can be done. It just has one trick that is the use of static variable to store the last row of data used or a loop and condition to check what value is currently in cell and then select the next value from dump. Problem is many o

Re: $$Excel-Macros$$ Please Help

2010-09-28 Thread siti Vi
please check the attached workbook On Mon, Sep 27, 2010 at 11:02 PM, hemant shah wrote: > Hi Team, > Can you please help on the attached file. > I have explained my query in the attached sheet. > Regards, > Hemant Shah --

$$Excel-Macros$$ Re: Excel chart plotting, depending on weightage

2010-09-28 Thread anandydr
I copied the data you had in your previous post and tried to plot it using Excel 2007. 3D line charts are generated correctly if the temperatures are converted to TEXT instead of NUMBERS, i.e. use a single quotation mark " ' " before the number like in '10 instead of 10. Column charts and stacked c

$$Excel-Macros$$ Help with Formula

2010-09-28 Thread harris a
Hi, I need help with formula to calculate week on week and year on year changes. for example the data is Year 8-Sep 15-Sep 22-Sep 29-Sep 2009165.60 167.80 170.80 2010174.80 174.50 174.90 Every week one data