$$Excel-Macros$$ Shortcut for trace dependents
Can anyone tell me a short cut key for 'trace dependents'?? The shortcut key for 'trace precedents' is cntrl + [ for those who don't know. Look forward for a shortcut.. :-) Thanks and regards, Jaydeep --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Need Macros for Track Changes
Hi All, I want to know, if there is any other option, i.e., other than Track Changes. I want to know in my excel sheet, if someone does any changes in any column/Row/Cell for e.g., Adding one row in between of existing rows, changing the values of cells. There is a restriction in Track Changes, if someone has stop the Track Changes option, then it won't work. Therefore, I need to protect my data and find out if any invaluable changes are going on in a different workbook or in the different worksheet. -- Best Regards Pooja Sharma --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Using DDE with Excel 2007 to create an Excel 2003 workbook
the code below could work. "ActiveWorkbook.SaveAs "C:\ron.xlsm", fileformat:=52 " the fileformat value could be changed as follows *51* = xlOpenXMLWorkbook (without macro's in 2007, xlsx) *52* = xlOpenXMLWorkbookMacroEnabled (with or without macro's in 2007, xlsm) *50* = xlExcel12 (Excel Binary Workbook in 2007 with or without macro's, xlsb) *56* = xlExcel8 (97-2003 format in Excel 2007, xls) thanks Regards, Vivek Agrawal Contact No. +91--154-077 Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Thu, Jul 9, 2009 at 1:01 AM, steve.bags...@itmetrics.com < steve.bags...@itmetrics.com> wrote: > > I am using DDE to drive MS/Excel 2007 and would like to use SAVE.AS to > save the active workbook as a .xls, i.e. in excel 2003 format. > > Has anyone done this and if so can they provide a code sample? > > Thanks > Steve > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ error : can't find object or library
I got this error : can't find object or library whenever i try to enter some information into a cell. can someone advise how to get raid of it? thanks --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Using DDE with Excel 2007 to create an Excel 2003 workbook
I am using DDE to drive MS/Excel 2007 and would like to use SAVE.AS to save the active workbook as a .xls, i.e. in excel 2003 format. Has anyone done this and if so can they provide a code sample? Thanks Steve --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ need a function or a formula which will search a table and get max value from the table.
Hi, I am trying to write a function or a formula which will search from a range of data and compare with another list and populate the max value corresponding to it but not able to do so till now. What i am trying to do is that i will give a name and from a specified table it will search the where there is the name and maximum value will get populated which is corresponding to it. To add in the original table has multiple instance of the name that is to be provide. I have a macro which one of the member from this group has made but in macro i can use only the a definite relation where as here i have to use it at many place in the workbook. I have attached the file for your reference. Regards, Kunal Rout --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- help.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Stop with output subroutine
I finally got this to work, sort of. For those curious about the code, it calculates least squares polynomial regression. To get it to work, I had to do the following Change B(i) to B(1) Know that it will continue to do the the do loop. I had to set the end condition in a subroutine so when it went back it would stop. Note it finishes one more loop than needed some I am getting some garbage data but I can accept that. The initial go sub worked great but needed be pulled out of the main program. When the loop was done it launched the subroutine again. This seems to work great with integers. Real numbers may be a bit off but at least initial numbers are close to the values I had for the original test problem. Doing a check of my results showed that I solved the related problem so I accept the results. On Jul 2, 9:46 am, larry wrote: > Thanks for the idea but it doesn't seem to work. I am probably messing > up the subroutine formats. I hate to post long code but here it is. > Any advice would be welcome. > > Option Explicit > Dim A(11, 12) As Variant, XX_values(11, 11) As Variant, XY_values(11) > As Variant > Dim X(200) As Variant, Y(200) As Variant, B(11) As Variant > Public Num As Integer, I As Integer, J As Integer, K_degree As > Integer, Row_Count As Integer > Public Sum_X As Double, Sum_Y As Double, Sum_XY As Double, Sum_XS As > Double > Public PM_SSQ As Double, N As Integer, M As Integer, K As Integer, > Diff As Double > Public Sum_Sq As Double, Prod As Double, Y_Hat As Double, CM_SSQ As > Double > Public Sum1 As Double, Sum2 As Double, Sum3 As Double, XK As Double > Sub LSPR() > Application.EnableEvents = False > Num = Cells(2, 2).Value > Sum_X = 0# > Sum_Y = 0# > Sum_XY = 0# > Sum_XS = 0# > Row_Count = 10 > For I = 1 To Num > X(I) = Cells(I + 1, 5).Value > Y(I) = Cells(I + 1, 6).Value > Sum_Y = Sum_Y + Y(I) > Sum_X = Sum_X + X(I) > Sum_XY = Sum_XY + X(I) * Y(I) > Sum_XS = Sum_XS + X(I) * X(I) > Next I > PM_SSQ = 10# > K_degree = 1 > N = K_degree + 1 > M = N + 1 > XX_values(1, 1) = Num > XX_values(1, 2) = Sum_X > XX_values(2, 1) = Sum_X > XX_values(2, 2) = Sum_XS > XY_values(1) = Sum_Y > XY_values(2) = Sum_XY > Do Until K_degree = 10 > For I = 1 To N > For J = 1 To N > A(I, J) = XX_values(I, J) > Next J > A(I, M) = XY_values(I) > Next I > GoSub Jordan > Sum_Sq = 0# > For I = 1 To Num > Prod = 0# > For J = 1 To K_degree > Prod = Prod + A(J + 1, M) * X(I) ^ J > Next J > Y_Hat = A(1, M) + Prod > Sum_Sq = Sum_Sq + (Y(I) - Y_Hat) ^ 2 > Next I > If Num - K_degree - 1 = 0 Then Call Out_put > CM_SSQ = Sum_Sq / (Num - K_degree - 1) > If CM_SSQ >= PM_SSQ Then Call Out_put > Cells(Row_Count, 1).Value = K_degree > Cells(Row_Count, 2).Value = "Degree Polynomial Coefficients" > Row_Count = Row_Count + 1 > Cells(Row_Count, 1).Value = "Beta" > Cells(Row_Count, 3).Value = "CMSSQ" > For I = 1 To N > Row_Count = Row_Count + 1 > Cells(Row_Count, 1).Value = I - 1 > Cells(Row_Count, 2).Value = A(I, M) > Next I > Cells(Row_Count, 3).Value = CM_SSQ > Row_Count = Row_Count + 2 > PM_SSQ = CM_SSQ > K_degree = K_degree + 1 > N = K_degree + 1 > M = N + 1 > For I = 1 To K_degree - 1 > XX_values(K_degree + 1, I) = XX_values(K_degree, I + 1) > XX_values(I, K_degree + 1) = XX_values(K_degree + 1, I) > Next I > Sum1 = 0 > Sum2 = 0 > Sum3 = 0 > For I = 1 To Num > XK = X(I) ^ K_degree > Sum1 = Sum1 + XK * X(I) ^ (K_degree - 1) > Sum2 = Sum2 + XK * XK > Sum3 = Sum3 + XK * Y(I) > Next I > XX_values(K_degree + 1, K_degree) = Sum1 > XX_values(K_degree + 1, K_degree + 1) = Sum2 > XX_values(K_degree, K_degree + 1) = Sum1 > XY_values(K_degree + 1) = Sum3 > For J = 1 To K > B(J) = A(J, N) > Next J > Loop > Jordan: > For K = 1 To N > For J = (K + 1) To M > A(K, J) = A(K, J) / A(K, K) > Next J > For I = 1 To N > If I <> K Then > For J = (K + 1) To M > A(I, J) = A(I, J) - A(I, K) * A(K, J) > Next J > End If > Next I > Next K > Return > End Sub > > Sub Out_put() > Cells(1, 11).Value = K_degree - 1 > For I = 1 To Num > Prod = 0# > For J = 1 To K_degree - 1 > Prod = Prod + B(J + 1) * X(I) ^ J > Next J > Y_Hat = B(I) + Prod > Diff = Y(I) - Y_Hat > Cells(I + 1, 7).Value = Y_Hat > Cells(I + 1, 8).Value = Diff > Next I > Application.EnableEvents = True > End Sub > > On Jul 1, 10:59 pm, Dave Bonallack wrote: > > > > > Hi Larry, > > > Usual cause of that behaviour is other event macros. > > > Start with: Application.EnableEvents = False > > > Then your code. > > > Then at the end: Application.EnableEvents = True > > > Regards - Dave. > > > _ > > View photos of singles in your area Click
$$Excel-Macros$$ Re: Outlook urgent
Thanks for the help Daniel... Regards, Shrinivas Query Unit Securities Services Global Transaction Services - India. Ph: +91-80-41446339 E-Mail: shrinivas.chidur...@citi.com -Original Message- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel Sent: Wednesday, July 08, 2009 1:33 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook urgent I am no expert with Outlook. But as I figure it out, it looks like if the attached file is embedded in RTF. If this is exact, you can't have plain text format with attached files. You better address an Outlook forum. You could try the NNTP newsgroup : microsoft.public.outlook.general Regards. Daniel > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel- > mac...@googlegroups.com] De la part de Chidurala, Shrinivas > Envoyé : mardi 7 juillet 2009 18:54 > À : excel-macros@googlegroups.com > Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: Outlook urgent > > > Daniel, > > If we create draft with out attachment then its working, but not > working with attached. > > Please can you check. > > Regards, > Shrinivas > Query Unit > Securities Services > Global Transaction Services - India. > Ph: +91-80-41446339 > E-Mail: shrinivas.chidur...@citi.com > > -Original Message- > From: excel-macros@googlegroups.com > [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel > Sent: Monday, July 06, 2009 6:10 PM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Re: Outlook urgent > > > > Hello. > > Try : > > Sub SimpleMail() > Dim olApp, m > Set olApp = CreateObject("Outlook.application") > Set m = olApp.CreateItem(olMailItem) > With m > .Subject = "Subject" > .Body = "Dear All," & Chr(10) & Chr(10) & _ > "Find attached report as of 04-Jul-2009." & _ > Chr(10) & Chr(10) & _ > "Regards," & Chr(10) & "Shrinivas" > .Recipients.Add "t...@test.com" > .attachments.Add "C:\Temp\ICICI.xls" > .BodyFormat = olFormatPlain > .display ' to be deleted > .Save > End With > Set m = Nothing > Set olApp = Nothing > End Sub > > Regards. > Daniel > > > -Message d'origine- > > De : excel-macros@googlegroups.com [mailto:excel- > > mac...@googlegroups.com] De la part de Chidurala, Shrinivas > > Envoyé : lundi 6 juillet 2009 07:27 > > À : excel-macros@googlegroups.com > > Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: Outlook urgent > > > > > > Daniel, > > > > It working but i want draft format should be in plain text or HTML. > now > > it is in Rich text. > > > > Please can u help on this. > > > > Regards, > > Shrinivas > > Query Unit > > Securities Services > > Global Transaction Services - India. > > Ph: +91-80-41446339 > > E-Mail: shrinivas.chidur...@citi.com > > > > -Original Message- > > From: excel-macros@googlegroups.com > > [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel > > Sent: Saturday, July 04, 2009 8:06 PM > > To: excel-macros@googlegroups.com > > Subject: $$Excel-Macros$$ Re: Outlook urgent > > > > > > > > Hi, Shrinivas. > > > > Try : > > > > Sub SimpleMail() > > Dim olApp, m > > Set olApp = CreateObject("Outlook.application") > > Set m = olApp.CreateItem(olMailItem) > > With m > > .Subject = "Subject" > > .Body = "Dear All," & Chr(10) & Chr(10) & _ > > "Find attached report as of 04-Jul-2009." & _ > > Chr(10) & Chr(10) & _ > > "Regards," & Chr(10) & "Shrinivas" > > .Recipients.Add "t...@test.com" > > .attachments.Add "C:\Temp\ICICI.xls" > > .display > > .Save > > End With > > Set m = Nothing > > Set olApp = Nothing > > End Sub > > > > Regards. > > > > Daniel > > > > > -Message d'origine- > > > De : excel-macros@googlegroups.com [mailto:excel- > > > mac...@googlegroups.com] De la part de Chidurala, Shrinivas > > > Envoyé : samedi 4 juillet 2009 14:55 > > > À : excel-macros@googlegroups.com > > > Cc : bal...@gmail.com > > > Objet : [Norton AntiSpam] $$Excel-Macros$$ Outlook urgent > > > Importance : Haute > > > > > > Dear Friends, > > > > > > I requeired i coding to create a draft with attachement and also > the > > > draft format should be in plain text. > > > > > > Find attached draft for your reference. > > > > > > Thanks & Regards, > > > Shrinivas > > > > > > > > > > > > > > > > > > > > > > > > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to ex
$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row
Hey Daniel this was fantastic... thanks for the knowledge Regards, Vivek Agrawal Contact No. +91--154-077 Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 8, 2009 at 5:07 PM, Daniel wrote: > Hi, > > Select the column, Ctrl+H, what : “~*” (without the quotes), replace all. > > Regards. > > Daniel > > > > > > *De :* excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > *De la part de* Manoj S Negi > *Envoyé :* mercredi 8 juillet 2009 12:07 > *À :* excel-macros@googlegroups.com > *Objet :* [Norton AntiSpam] $$Excel-Macros$$ Need help to remove the * > from cell & entire row > > > > Hi Friends, > > Please help meas my query is as follows... > In the attached sheet in column there is some data and some cells are > having * and I want to remove the * from the cells. > Kindly look into this and advice ... > > Thanks for your support. > > > > Unfeigned Regards > Manoj S Negi > > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Check Box macro
Thank You Gents, fantastic as ever..so many ways to Skin A Cat On Jul 8, 1:27 am, "Ajit Navre" wrote: > Hi Dave, > > Please take a look at the attached workbook- hope this is what you are > looking for- > > (Start from the ThisWorkBook - WorkBookOpen Event Procedure.) > > Regards, > > Ajit > > > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > > On Behalf Of Dave > Sent: Tuesday, July 07, 2009 8:53 PM > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Check Box macro > > Hi Group, > > I have a very simple request. I have an excel spreadsheet setup as a > check list for a very complicated audit process. I am using MS Excel > 2003 and using the Check Box on this check list. > > What I want to do is when a person clicks on a check box on this > worksheet I want Excel to popup a message saying "Please Fill the > Related Entities Spreadsheet, thanks" & that it. I was thinking of a > macro that could do this. > > thanks in advance, > > Dave > > > > ChkBoxCol.xls > 68KViewDownload- Hide quoted text - > > - Show quoted text - --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Curious RefEdit issue
I can't reproduce it. Can you attach your workbbok to your response ? Daniel > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel- > mac...@googlegroups.com] De la part de dom > Envoyé : mercredi 8 juillet 2009 16:55 > À : MS EXCEL AND VBA MACROS > Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: Curious RefEdit issue > > > There is no code involved - the form with the RefEdit control is > displayed I have a cancel button that simply unloads the form but the > RefEdit box still has control of Excel. I have got a workaround by > not having the RefEdit be the first control with focus as then when it > gets the focus you are forced to handle it before you can see the > screen to select cancel, but if it gets the focus on display it is too > late... > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row
Very Good Daniel/Norman...You have got excellent knowledge of Excel.. Keep it up !! On Jul 8, 8:26 pm, Manoj S Negi wrote: > Hi All, > > Thanks a lot for you allmy query has been resolved by your nice > solutions. > Really very nice tricks I got from you all. > > Cheers... > > *Unfeigned Regards > Manoj S Negi > "Miles & miles to go before I sleep"* > > On Wed, Jul 8, 2009 at 5:07 PM, Daniel wrote: > > Hi, > > > Select the column, Ctrl+H, what : “~*” (without the quotes), replace all. > > > Regards. > > > Daniel > > > *De :* excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > > *De la part de* Manoj S Negi > > *Envoyé :* mercredi 8 juillet 2009 12:07 > > *À :* excel-macros@googlegroups.com > > *Objet :* [Norton AntiSpam] $$Excel-Macros$$ Need help to remove the * > > from cell & entire row > > > Hi Friends, > > > Please help meas my query is as follows... > > In the attached sheet in column there is some data and some cells are > > having * and I want to remove the * from the cells. > > Kindly look into this and advice ... > > > Thanks for your support. > > > Unfeigned Regards > > Manoj S Negi --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row
Hi All, Thanks a lot for you allmy query has been resolved by your nice solutions. Really very nice tricks I got from you all. Cheers... *Unfeigned Regards Manoj S Negi "Miles & miles to go before I sleep"* On Wed, Jul 8, 2009 at 5:07 PM, Daniel wrote: > Hi, > > Select the column, Ctrl+H, what : “~*” (without the quotes), replace all. > > Regards. > > Daniel > > > > > > *De :* excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] > *De la part de* Manoj S Negi > *Envoyé :* mercredi 8 juillet 2009 12:07 > *À :* excel-macros@googlegroups.com > *Objet :* [Norton AntiSpam] $$Excel-Macros$$ Need help to remove the * > from cell & entire row > > > > Hi Friends, > > Please help meas my query is as follows... > In the attached sheet in column there is some data and some cells are > having * and I want to remove the * from the cells. > Kindly look into this and advice ... > > Thanks for your support. > > > > Unfeigned Regards > Manoj S Negi > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Curious RefEdit issue
There is no code involved - the form with the RefEdit control is displayed I have a cancel button that simply unloads the form but the RefEdit box still has control of Excel. I have got a workaround by not having the RefEdit be the first control with focus as then when it gets the focus you are forced to handle it before you can see the screen to select cancel, but if it gets the focus on display it is too late... --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: To make the color of the cell white
This line of code bellow will copy the value of the selected cell to next cell i.e. value of A1 to B1 retaining the formatting of B1 Selection.Offset(0, 1).Value = Selection.Value hope this helps Thanks Regards, Vivek Agrawal Contact No. +91--154-077 Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Jul 6, 2009 at 10:34 PM, tushar patki wrote: > Dear All, > > I have written a code which will copy cell contents from one cell to > another. Along with the cell contents, also formatting of the cell is > copied. I am not able to code and keep the formatting as I want. For eg. > > Cell A1 has color yellow. > I copied cell A1 to B1. > > The color also gets copied. Please tell me the code which will again retain > the white colour again. > > I tried with RGB function, also with interior property, but I am unable to > do the same. Pl guide me. > > > -- > Regards > Tushar S Patki > CA > Contact Details - > 2106, Sadashiv Peth, > Dattaprasad Apartment, > Pune - 411030. > State: Maharashtra > Country: India > Phone - +91-020-24337003 > Mobile - 09850715116 > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: To make the color of the cell white
you can also try this select the cells in which you want to apply your formatting... run this code below === Sub ApplyMyFormat() With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .ThemeColor = xlThemeColorAccent6 .TintAndShade = -0.24997717893 .PatternTintAndShade = 0 End With With Selection.Font .ThemeColor = xlThemeColorLight1 .TintAndShade = 0.349986266670736 End With End Sub === this could apply a particular format to your cell... now you can change the values to suit your format. if you want to know code for specific format, then please let me know.. if possible apply the desired format in a spreadsheet to a cell, and mail the file. Regards, Vivek Agrawal Contact No. +91--154-077 Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Mon, Jul 6, 2009 at 10:34 PM, tushar patki wrote: > Dear All, > > I have written a code which will copy cell contents from one cell to > another. Along with the cell contents, also formatting of the cell is > copied. I am not able to code and keep the formatting as I want. For eg. > > Cell A1 has color yellow. > I copied cell A1 to B1. > > The color also gets copied. Please tell me the code which will again retain > the white colour again. > > I tried with RGB function, also with interior property, but I am unable to > do the same. Pl guide me. > > > -- > Regards > Tushar S Patki > CA > Contact Details - > 2106, Sadashiv Peth, > Dattaprasad Apartment, > Pune - 411030. > State: Maharashtra > Country: India > Phone - +91-020-24337003 > Mobile - 09850715116 > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Separate Fields in fastest way
Can you post what result you do expect. It is not clear to me how the parsing have to be made. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Deepak Rawat Envoyé : mercredi 8 juillet 2009 07:20 À : excel-macros@googlegroups.com Objet : [Norton AntiSpam] $$Excel-Macros$$ Separate Fields in fastest way Dear friends have attached a file in which all fields are merged and have to separate all fields as soon as possible. pl suggest me the way. there is another problem, i want to filter the records which have character and not numbers is there any wild card combination to apply such filter. Regards, Deepak Rawat --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Curious RefEdit issue
Can you post your code ? Daniel > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel- > mac...@googlegroups.com] De la part de dom > Envoyé : mercredi 8 juillet 2009 10:48 > À : MS EXCEL AND VBA MACROS > Objet : [Norton AntiSpam] $$Excel-Macros$$ Curious RefEdit issue > > > I am building a wizard for some users that uses the Refedit Control. > However if they cancel out of the wizard without entering the control, > somehow the RefEdit control has taken control of Excel and I can only > terminate the Excel process. I am probably doing something obviously > wrong but I can't see what!! > > Any help gratefully received. > > Dom > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row
Manoj, In the find and replace box precede the asterisk with a tilde. Example: ~* Norman On Wed, Jul 8, 2009 at 6:06 AM, Manoj S Negi < manojsnegi.uttranc...@gmail.com> wrote: > Hi Friends, > > Please help meas my query is as follows... > In the attached sheet in column there is some data and some cells are > having * and I want to remove the * from the cells. > Kindly look into this and advice ... > > Thanks for your support. > > > > Unfeigned Regards > Manoj S Negi > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row
Hi, Select the column, Ctrl+H, what : “~*” (without the quotes), replace all. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Manoj S Negi Envoyé : mercredi 8 juillet 2009 12:07 À : excel-macros@googlegroups.com Objet : [Norton AntiSpam] $$Excel-Macros$$ Need help to remove the * from cell & entire row Hi Friends, Please help meas my query is as follows... In the attached sheet in column there is some data and some cells are having * and I want to remove the * from the cells. Kindly look into this and advice ... Thanks for your support. Unfeigned Regards Manoj S Negi --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row
hi manoj i am new in useing excel On 7/8/09, Manoj S Negi wrote: > > Hi Friends, > > Please help meas my query is as follows... > In the attached sheet in column there is some data and some cells are > having * and I want to remove the * from the cells. > Kindly look into this and advice ... > > Thanks for your support. > > > > Unfeigned Regards > Manoj S Negi > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- msn.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: Need help to remove the * from cell & entire row
Manoj, Attached is the file with macro. You just need to select the respective cell and run the macro. Thanks Regards, Vivek Agrawal Contact No. +91--154-077 Skype ID - vivek.agrawal83 GoogleMoonlight.com - Saving energy-Save Earth On Wed, Jul 8, 2009 at 3:36 PM, Manoj S Negi < manojsnegi.uttranc...@gmail.com> wrote: > Hi Friends, > > Please help meas my query is as follows... > In the attached sheet in column there is some data and some cells are > having * and I want to remove the * from the cells. > Kindly look into this and advice ... > > Thanks for your support. > > > > Unfeigned Regards > Manoj S Negi > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- msn.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Need help to remove the * from cell & entire row
Hi Friends, Please help meas my query is as follows... In the attached sheet in column there is some data and some cells are having * and I want to remove the * from the cells. Kindly look into this and advice ... Thanks for your support. Unfeigned Regards Manoj S Negi --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~--- msn.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Re: To make the color of the cell white
You can use paste Special-> values in you macro Regards, Upendra Singh +91-9910227325, +91-9310760597 - There are 10 kinds of people: Those who understand binary and those who don't. - On 7/6/09, tushar patki wrote: > Dear All, > > I have written a code which will copy cell contents from one cell to > another. Along with the cell contents, also formatting of the cell is > copied. I am not able to code and keep the formatting as I want. For eg. > > Cell A1 has color yellow. > I copied cell A1 to B1. > > The color also gets copied. Please tell me the code which will again retain > the white colour again. > > I tried with RGB function, also with interior property, but I am unable to > do the same. Pl guide me. > > > -- > Regards > Tushar S Patki > CA > Contact Details - > 2106, Sadashiv Peth, > Dattaprasad Apartment, > Pune - 411030. > State: Maharashtra > Country: India > Phone - +91-020-24337003 > Mobile - 09850715116 > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Averagees
Hi I need to work out if on an average of 20 scores a person scores 3.7 . What would the person need to get on their next sores to acive a average of 3. the scores that can be acieved are 1 to 5 so basically how many 3's or 2's or 1's would they need --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Curious RefEdit issue
I am building a wizard for some users that uses the Refedit Control. However if they cancel out of the wizard without entering the control, somehow the RefEdit control has taken control of Excel and I can only terminate the Excel process. I am probably doing something obviously wrong but I can't see what!! Any help gratefully received. Dom --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Use of Offset
Hi. Mahesh, OFFSET is either an Excel function or a VBA method. I’ll explain the Excel function first. It is simplest to give some examples : =OFFSET(B2,1,0) is equal to : B3 (shifting one row downwards) =OFFSET(B2,-1,0) is equal to : B1 (shifting one row upwards) =OFFSET(B2,0,2) is equal to : D2 (shifting two columns to the right) =OFFSET(B2,2,2) is equal to : D4 (shifting two rows downwards and two columns to the right) Furthermore, you can select a range : =OFFSET(B2,0,0,5,2) Means you select a range 5 rows x 2 columns, starting from B2. =OFFSET(B2,-1,0,5,2) Means you select a range 5 rows x 2 columns, starting from B1. =SUM(OFFSET(B2,-1,0,5,2)) is equivalent to : =SUM(B1:C5) The VBA method enables you to make shifts. You’ll have to use the Resize property to define multi cells ranges : The equivalent of =OFFSET(B2,-1,0,5,2) Would be : [B2].Offset(-1,0).Resize(5,2) Hope this helps. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Mahesh Envoyé : mercredi 8 juillet 2009 06:40 À : excel-macros@googlegroups.com Objet : [Norton AntiSpam] $$Excel-Macros$$ Use of Offset Hi All, Please tell me what is the use of OFFSET Command. -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: Outlook urgent
I am no expert with Outlook. But as I figure it out, it looks like if the attached file is embedded in RTF. If this is exact, you can't have plain text format with attached files. You better address an Outlook forum. You could try the NNTP newsgroup : microsoft.public.outlook.general Regards. Daniel > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel- > mac...@googlegroups.com] De la part de Chidurala, Shrinivas > Envoyé : mardi 7 juillet 2009 18:54 > À : excel-macros@googlegroups.com > Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: Outlook urgent > > > Daniel, > > If we create draft with out attachment then its working, but not > working with attached. > > Please can you check. > > Regards, > Shrinivas > Query Unit > Securities Services > Global Transaction Services - India. > Ph: +91-80-41446339 > E-Mail: shrinivas.chidur...@citi.com > > -Original Message- > From: excel-macros@googlegroups.com > [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel > Sent: Monday, July 06, 2009 6:10 PM > To: excel-macros@googlegroups.com > Subject: $$Excel-Macros$$ Re: Outlook urgent > > > > Hello. > > Try : > > Sub SimpleMail() > Dim olApp, m > Set olApp = CreateObject("Outlook.application") > Set m = olApp.CreateItem(olMailItem) > With m > .Subject = "Subject" > .Body = "Dear All," & Chr(10) & Chr(10) & _ > "Find attached report as of 04-Jul-2009." & _ > Chr(10) & Chr(10) & _ > "Regards," & Chr(10) & "Shrinivas" > .Recipients.Add "t...@test.com" > .attachments.Add "C:\Temp\ICICI.xls" > .BodyFormat = olFormatPlain > .display ' to be deleted > .Save > End With > Set m = Nothing > Set olApp = Nothing > End Sub > > Regards. > Daniel > > > -Message d'origine- > > De : excel-macros@googlegroups.com [mailto:excel- > > mac...@googlegroups.com] De la part de Chidurala, Shrinivas > > Envoyé : lundi 6 juillet 2009 07:27 > > À : excel-macros@googlegroups.com > > Objet : [Norton AntiSpam] $$Excel-Macros$$ Re: Outlook urgent > > > > > > Daniel, > > > > It working but i want draft format should be in plain text or HTML. > now > > it is in Rich text. > > > > Please can u help on this. > > > > Regards, > > Shrinivas > > Query Unit > > Securities Services > > Global Transaction Services - India. > > Ph: +91-80-41446339 > > E-Mail: shrinivas.chidur...@citi.com > > > > -Original Message- > > From: excel-macros@googlegroups.com > > [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel > > Sent: Saturday, July 04, 2009 8:06 PM > > To: excel-macros@googlegroups.com > > Subject: $$Excel-Macros$$ Re: Outlook urgent > > > > > > > > Hi, Shrinivas. > > > > Try : > > > > Sub SimpleMail() > > Dim olApp, m > > Set olApp = CreateObject("Outlook.application") > > Set m = olApp.CreateItem(olMailItem) > > With m > > .Subject = "Subject" > > .Body = "Dear All," & Chr(10) & Chr(10) & _ > > "Find attached report as of 04-Jul-2009." & _ > > Chr(10) & Chr(10) & _ > > "Regards," & Chr(10) & "Shrinivas" > > .Recipients.Add "t...@test.com" > > .attachments.Add "C:\Temp\ICICI.xls" > > .display > > .Save > > End With > > Set m = Nothing > > Set olApp = Nothing > > End Sub > > > > Regards. > > > > Daniel > > > > > -Message d'origine- > > > De : excel-macros@googlegroups.com [mailto:excel- > > > mac...@googlegroups.com] De la part de Chidurala, Shrinivas > > > Envoyé : samedi 4 juillet 2009 14:55 > > > À : excel-macros@googlegroups.com > > > Cc : bal...@gmail.com > > > Objet : [Norton AntiSpam] $$Excel-Macros$$ Outlook urgent > > > Importance : Haute > > > > > > Dear Friends, > > > > > > I requeired i coding to create a draft with attachement and also > the > > > draft format should be in plain text. > > > > > > Find attached draft for your reference. > > > > > > Thanks & Regards, > > > Shrinivas > > > > > > > > > > > > > > > > > > > > > > > > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friend
$$Excel-Macros$$ Urgent VBA excel code required to find the worksheet with reference to the name provided in the cell
Hi all, I have been assigned a project wherein I have a worksheet (named "General") with a list of names (these are the name of worksheet which is there in the same workbook) and some values which I need to go and paste in the respective worksheets. Here what I need to do is search the worksheet whose name is provided in "General" worksheet and then I have to paste the values in that worksheet. The only issue with the names provided is only starting 5 characters of the name provided match with the exact worksheet name. I need a vba code which can find the worksheet with reference to the name given in the worksheet (named "General") and then paste the values in the respective worksheets. Guys please help. Thanks in advance, Ramkrishna T. Padhi --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Re: To make the color of the cell white
Hi write a code like Range("b1").Interior.ColorIndex = 0 I hope this help you Jayavelu On 7/6/09, tushar patki wrote: > Dear All, > > I have written a code which will copy cell contents from one cell to > another. Along with the cell contents, also formatting of the cell is > copied. I am not able to code and keep the formatting as I want. For eg. > > Cell A1 has color yellow. > I copied cell A1 to B1. > > The color also gets copied. Please tell me the code which will again retain > the white colour again. > > I tried with RGB function, also with interior property, but I am unable to > do the same. Pl guide me. > > > -- > Regards > Tushar S Patki > CA > Contact Details - > 2106, Sadashiv Peth, > Dattaprasad Apartment, > Pune - 411030. > State: Maharashtra > Country: India > Phone - +91-020-24337003 > Mobile - 09850715116 > > > > --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---
$$Excel-Macros$$ Use of Offset
Hi All, Please tell me what is the use of OFFSET Command. -- With Love, Mahesh Bisht --~--~-~--~~~---~--~~ -- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 5,000 subscribers worldwide and receive many nice notes about the learning and support from the group. Our goal is to have 10,000 subscribers by the end of 2009. Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -~--~~~~--~~--~--~---