$$Excel-Macros$$ watermark

Dear experts How to get watermark impression on the userform while taking printout ? regards shankar sb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, an

Re: $$Excel-Macros$$ Turn Tab Order on/off

Hi Asa and Don Thanks for all your comments and help. Now I see what it is doing, as you explained in your emails. Yes it does work, in quite a different way to what I was expecting. My apologies for being so dumb. With this sheet it is normally filled in once and not all of the tabbed cells wi

Re: $$Excel-Macros$$ - Sunil B.N

Didn't try, but should work - http://answers.yahoo.com/question/index?qid=20071016005523AAlKbBa On Tue, Mar 27, 2012 at 11:36 AM, sunil bn wrote: > Dear All, > > Please find the attached file. > > I Need the formula for Number to text in Indian Currency > > Attached file of your reference pls

$$Excel-Macros$$ printing doubt

Dear experts for a command button of an userform for Printing of sheets purpose I am using code as sheets("sheet1").printout whereas, i need to print 3rd page of sheet1 everytime, so what change is required in the above code to get only 3rd page. regards shankar sb -- FORUM RULES (986+ membe

$$Excel-Macros$$ need help:save excel worksheet data into SQLserver using VBA code

Hi, Dear expert, I have a daily work table, i use it every day, i want to send this excel worksheet table to SQLSERVER database, but i do not know how, can you give me VBA code to instruct me how to do it ? I use SQL 2008, thanks in advance. B.R. -- FORUM RULES (986+ members already BANNED fo

RE: $$Excel-Macros$$ Re: Arry Formula help

thank you so much ASA. thanks for all your help. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not

Re: $$Excel-Macros$$ vlookup with more than one value

Dear finos, Anotherway to calculate amount. On Tue, Mar 27, 2012 at 7:45 AM, NOORAIN ANSARI wrote: > Dear Finos, > > Please see attached sheet, hope it help to you. > > -- > Thanks & regards, > Noorain Ansari > *http://noorainansari.com/* > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Re: Is there a way to tell excel the first row is definitely data and not column names?

Well, I see it does know so never mind. On Monday, March 26, 2012 8:21:06 PM UTC-7, tangledweb wrote: > If I reply to that address, how does it know which thread to attach to? > > On Mon, Mar 26, 2012 at 8:10 PM, Domain Admin > wrote: > > Thanks again. Will try that. > > > > On Mon, Mar 2

Re: $$Excel-Macros$$ Re: Is there a way to tell excel the first row is definitely data and not column names?

If I reply to that address, how does it know which thread to attach to? On Mon, Mar 26, 2012 at 8:10 PM, Domain Admin wrote: > Thanks again.  Will try that. > > On Mon, Mar 26, 2012 at 8:00 PM, Asa Rossoff wrote: >> I had posted in your "So is it common..." thread.  Odd about creating a >> threa

$$Excel-Macros$$ Is there a way to align VBA program text for readability (example inside)

For example adfdf = 123 jsfldfjdkfj = 256 and I want it to look like adfdf = 123 jsfldfjdkfj = 256 But in the VBA editor whenever I add tabs or spaces for alignment it removes them. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor

$$Excel-Macros$$ Re: So is it common for even an easy question on the forum to not get answered?

Thanks, that works. On Friday, March 23, 2012 12:41:57 AM UTC-7, Asa R. wrote: > Hi H., > Not sure how you are determining that Excel knows or doesn't know your > column headings are column headings. > > Do you mean it guesses correctly when you go to sort your data whether you > have headings o

Re: $$Excel-Macros$$ Re: Is there a way to tell excel the first row is definitely data and not column names?

Thanks again. Will try that. On Mon, Mar 26, 2012 at 8:00 PM, Asa Rossoff wrote: > I had posted in your "So is it common..." thread.  Odd about creating a > thread.  I always participate in the group by email (you can send messages > to the group by emailing excel-macros@googlegroups.com) > > As

RE: $$Excel-Macros$$ Re: Is there a way to tell excel the first row is definitely data and not column names?

I had posted in your "So is it common..." thread. Odd about creating a thread. I always participate in the group by email (you can send messages to the group by emailing excel-macros@googlegroups.com) Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@google

Re: $$Excel-Macros$$ Re: Is there a way to tell excel the first row is definitely data and not column names?

Thank you. I did not see it but I do not know why as I did look. Now for some reason I can no longer start a new thread. The button for this is not there. Not sure if the problems are related or not. Thanks again. On Mon, Mar 26, 2012 at 7:46 PM, Asa Rossoff wrote: > Did you see my previous re

Re: $$Excel-Macros$$ DELETE BLANK ROW AND COLUMN

Thanks,but it only delete blank row and column,but not delete entire row and column. 111 111 111 after run,it be 111 111 111 not 111 111 111 please check. On Tuesday, March 27, 2012 10:27:13 AM UTC+8, NOORAIN ANSARI wrote: > > Dear Siraj, > > Please try it.. > >

RE: $$Excel-Macros$$ Re: Is there a way to tell excel the first row is definitely data and not column names?

Did you see my previous reply-- In the sort dialog, uncheck "My data has headers" in the upper-right corner. Conversely, you can check the box if you do have headers and it's not already checked. You can also format your headers in Bold/underline, and Excel will usually default to detecting t

Re: $$Excel-Macros$$ DELETE BLANK ROW AND COLUMN

Dear Siraj, Please try it.. Sub delete_blankrowColumn() Cells.SpecialCells(xlCellTypeBlanks).Rows.Delete Cells.SpecialCells(xlCellTypeBlanks).Columns.Delete End Sub -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*

$$Excel-Macros$$ Re: DELETE BLANK ROW AND COLUMN

Sub delrowcolumn() Dim Area_ As Range Dim Rng1 As Range Dim Rng2 As Range Dim Ro As Long Dim Col As Integer Dim lstRo As Long Dim lstCol As Integer If [a1] = "" Then [a1] = 1 Set Area_ = ActiveSheet.UsedRange [a1].ClearContents lstRo = Area_.rows.Count

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Thank you very much to all of you. 2012/3/23 Abdulgani Shaikh > Excellent, expert in Excel as well expert Poet > > What a combination...Great. > > > 2012/3/23 Venkat CV > >> Dear Noorain, >> >> Superb >> >> *Best Regards,* >> *Venkat * >> *Chennai* >> >> >> 2012/3/23 NOORAIN ANSARI >>

Re: $$Excel-Macros$$ Error message on Excel

Dear Selva, Please share your vba code with group or check below link.. http://support.microsoft.com/kb/2655178 -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Tue, Mar 27, 2012 at 6:11 AM, LearnE

Re: $$Excel-Macros$$ vlookup with more than one value

Dear Finos, Please see attached sheet, hope it help to you. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Sat, Mar 24, 2012 at 7:27 PM, finu kodokodan wrote: > > > Please find the attached shee

$$Excel-Macros$$ Error message on Excel

I use a VBA code to copy and paste lots of info but recently i get a error message "Excel Cannot complete this tast with avaiable resources. choose less data or close other application" i tried just about everything and so far nothing works any recommendations? -- FORUM RULES (986+ members

$$Excel-Macros$$ Re: Is there a way to tell excel the first row is definitely data and not column names?

I have several columns of text data. Excel wants to make the first row column names so they do not get sorted when I sort the columns. Is there a way to tell excel to treat the row as data and not column names/headers (and conversely can you tell it to make the first row be column names when i

FW: $$Excel-Macros$$ Digest for excel-macros@googlegroups.com - 25 Messages in 15 Topics

-- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thr

$$Excel-Macros$$ DELETE BLANK ROW AND COLUMN

Dear Friends I need to delete blank row and blank column from the attached file with the help of macro because data is large. Thanks Siraj -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help,

Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

Thanks a log Indrajit, I am searching for such kind of solution, as you are already working on log-out time tracking, please send after completion of your VB code. Regards On Thu, Mar 22, 2012 at 3:51 AM, Indrajit $nai wrote: > Thanks @ Ranjan, but I don't track it in MS-Access File, can you >

$$Excel-Macros$$ Need to Know-- CAN WE PULL BITMAP DATA TO EXCEL FORMAT

Hi Team, Help needed , What to know how we can pull bitmap image data to excel format any vb coding or excel formula . Regards, Rajesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

$$Excel-Macros$$ vlookup with more than one value

Please find the attached sheet . please help to me to solve this problem -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick

Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

Hearty Congratulation for doing such great job. I myself learn VBA through this forum only. Can you please tell me something more on Microsoft MVP Excel Regards On Thu, Mar 22, 2012 at 4:25 AM, Ayush Jain wrote: > Dear members,** > > > > I am proud to announce that the forum has co

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Excellent, expert in Excel as well expert Poet What a combination...Great. 2012/3/23 Venkat CV > Dear Noorain, > > Superb > > *Best Regards,* > *Venkat * > *Chennai* > > > 2012/3/23 NOORAIN ANSARI > >> जहाँ Excel के दीवानों की, है बहूत घनी आबादी. >> जहाँ Question,Answer करने की,है ख

Re: $$Excel-Macros$$ Re: कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Thanks Ayush... 2012/3/24 Ayush Jain > You always rock Noorain. This is really a great skill. > > Thanks for writing poem and your great contribution to forum > > -Ayush Jain > > On Thursday, 22 March 2012 18:42:08 UTC, NOORAIN ANSARI wrote: > >> जहाँ Excel के दीवानों की, है बहूत घनी आबादी. >>

$$Excel-Macros$$ Re: Insert rows with missing data

Damimkader: Thank you! This is very close. (And yes - I'm working with Excel 07). I should have provided more example data, and clarified that data may exist for several years (not just 2005). It can also exist for several other age groups (not just 1). (In fact, there are additional variables

Re: $$Excel-Macros$$ need a macro

*For, Compaign: =INDEX($A$4:$A$80,CEILING(COUNTA($E$3:E3)/COUNTA($A$4:$A$80),1)) For, Location: =INDEX($B$4:$B$80,COUNTIF($E$4:E4,E4))* Oops. Deleted too many rows on test sheet >> >> Don Guillett >> Microsoft MVP Excel >> SalesAid Software >> dguille...@gmail.com >> >> *From:* Amresh Maurya

$$Excel-Macros$$ Re: APPEAL

Hello, delete some raw date and shoud be fine :) On Monday, March 26, 2012 2:10:18 PM UTC+3, Bheema Shankar wrote: > > Dear Owner of the Community > > Recently posting query by an attachment was failed due to size of the > file. The returned comments by the server is that the blog is not > ac

Re: $$Excel-Macros$$ need a macro

exactly... thank you so much.. Regards Amresh On Mon, Mar 26, 2012 at 5:35 AM, BNS kumar wrote: > Hope this file serve your needs > > Regards > Kumar > > > On Mon, Mar 26, 2012 at 5:32 PM, Amresh Maurya > wrote: > >> Hi Friends, >> >> We have 77 campaign and 77 city lists , now what i need

Re: $$Excel-Macros$$ need a macro

Hope this file serve your needs Regards Kumar On Mon, Mar 26, 2012 at 5:32 PM, Amresh Maurya wrote: > Hi Friends, > > We have 77 campaign and 77 city lists , now what i need , each campaign > has 77 cities. > > We have attached file for reference. kindly check > > Regards > Amresh > > > -- > FO

$$Excel-Macros$$ need a macro

Hi Friends, We have 77 campaign and 77 city lists , now what i need , each campaign has 77 cities. We have attached file for reference. kindly check Regards Amresh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Pleas

FW: $$Excel-Macros$$ Sum of all the random numbers generated

Dear All, Can we get the required details? Regards, Saurabh Patel From: Saurabh Madhusudan Patel [mailto:saurabh.pa...@in.aegisglobal.com] Sent: Saturday, March 24, 2012 7:49 PM To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ Sum of all the random numbers generated

$$Excel-Macros$$ APPEAL

Dear Owner of the Community Recently posting query by an attachment was failed due to size of the file. The returned comments by the server is that the blog is not accepting more than .10 mb capacity. Please increase the size to enable posting with an attachment. regards shankar sb -- FORUM R

Re: $$Excel-Macros$$ How to add new mail id In Excel-macros google group

Dear Veeru, Please use below link to subscribe new Email ID. http://groups.google.com/group/excel-macros/subscribe -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*