$$Excel-Macros$$ Re: Store Cell formatting

2009-11-10 Thread Paul
Hemant, I was hoping someone would come up with an answer for you! I have an application that stores the entire workbook as data in Oracle tables. the actual document is retrieved and re-assembled. If changes are made, the Oracle database is updated. Now, users sometimes want to make cells

$$Excel-Macros$$ Re: procdure to limit the printing to fix number of times

2009-11-10 Thread Paul Schreiner
ASSUMING that column A ALWAYS has data, then you could use: '--- Private Sub Worksheet_Change(ByVal Target As Range)     If (Application.WorksheetFunction.CountA(Range(A:A)) = 10) Then   MsgBox You

$$Excel-Macros$$ Re: Need help in Pivot table

2009-11-10 Thread Muhammad Ahmed Khan
On Sun, Nov 8, 2009 at 9:11 PM, Dilip Pandey dilipan...@gmail.com wrote: Dear Mahesh, Attachment is solved as per your requirement. Thanks. -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On

$$Excel-Macros$$ Re: Conditional sum problem ( first ns and equal to certain values)

2009-11-10 Thread Tony from Work
Dear Dilip, Again many thanks for your answer, it helped my a lot to solve my problem. Apologies, in first I tried to generalize too much, and I wasn't very clear ( and my bad english doesn't help) By the way, even if your syntax helped my, I can't managed to get your formula working Maybe if

$$Excel-Macros$$ Pasting a block of cells/object

2009-11-10 Thread Chris
Hi, I would like to know if this is possible in excel 2007 and any pointers where to look. - I have a block of cells (like a sort of table) which I want to define as one object (is there any way I can do this) - Is it possible somehow with a single function to copy this object (or block of

$$Excel-Macros$$ Re: InputBox

2009-11-10 Thread Hemant Hegde
Hi Tommy Where did you get the code name.copy ? It doesnt work that way. Its very simple just write Range(a1)=name when you use = operator, the value on the right hand side is assigned to the variable on left side 2009/11/9 Tommy jntwh...@verizon.net I need to be able to insert text into

$$Excel-Macros$$ Re: Excel VBA dynamically fill ComboBox?

2009-11-10 Thread Deepak Rai
Hi, I am attaching a file which is based on the same logic. U can use the same logic for your requirement. Hope this will help u. Regards, Deepak Rai On Tue, Nov 10, 2009 at 12:11 PM, RolfJ r...@pacificsound.us wrote: Assuming that your country column is column A, place the following code