$$Excel-Macros$$ Re: How can a custom function know which cell its in?
What I'm trying to do is have a function do some calculations and display some result based on the row that its in. I couldn't find a way to pass in the address of the cell into the function. row() is exactly what I was looking for and it'll suit my needs. Thank you! On Jul 18, 1:08 am, JRF wrote: > You don't need a custom function just use the built in =row() > function > > You could create a custom function to determine the row of a cell > reference > > Function WhatsMyRow(TheCell As Range) > WhatsMyRow = TheCell.Row > End Function > > and then in any cell type =WhatsMyRow(A1) the cell will show 1 > > On Jul 17, 5:22 pm, Adrian wrote: > > > > > Is there a way to create a custom function that will print out row > > number that the function is in? > > > For example, in cell C5, I'll type '=whats_my_row_number()' and I > > would like it to say 5. > > > Thank you in advance, --~--~-~--~~~---~--~~ -- 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: How can a custom function know which cell its in?
You don't need a custom function just use the built in =row() function You could create a custom function to determine the row of a cell reference Function WhatsMyRow(TheCell As Range) WhatsMyRow = TheCell.Row End Function and then in any cell type =WhatsMyRow(A1) the cell will show 1 On Jul 17, 5:22 pm, Adrian wrote: > Is there a way to create a custom function that will print out row > number that the function is in? > > For example, in cell C5, I'll type '=whats_my_row_number()' and I > would like it to say 5. > > Thank you in advance, --~--~-~--~~~---~--~~ -- 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: DateStamp Macro Debug Help
Hi, I pasted your code into my XL2000. I don't get any error when inserting rows. Dave. > Date: Fri, 17 Jul 2009 12:36:21 -0700 > Subject: $$Excel-Macros$$ DateStamp Macro Debug Help > From: pogs...@gmail.com > To: excel-macros@googlegroups.com > > > Hey all, > > I found a very simple macro to track any changes made to any cell in a > row by datestamping the end of the row. > The issue comes in whenever i try to insert a row into the sheet, i > get an error: "Runtime Error 1004, Application-defined or Object- > defined error" and im not sure how to fix this. > > Here is a sample of my code: > > Public Sub Worksheet_Change(ByVal Target As Range) > If Target.Column = 1 Then > Application.EnableEvents = False > Target.Offset.Offset(0, 13) = Now() > Application.EnableEvents = True > End If > End Sub > > > Could anyone please point me in the right direction, how can i keep > this functionality and still be able to insert new rows into my > sheet? > > Thanks in advance! > > Best Regards, > Pogster > > > _ Get the latest news, goss and sport Make ninemsn your homepage! http://windowslive.ninemsn.com.au/article.aspx?id=813730 --~--~-~--~~~---~--~~ -- 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: DateStamp Macro Debug Help
This modified code seems to work Public Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then 'Application.EnableEvents = False On Error GoTo Errorhandler Target.Offset.Offset(0, 13) = Now() 'Application.EnableEvents = True End If Errorhandler: End Sub Norman On Fri, Jul 17, 2009 at 3:36 PM, Pogster wrote: > > Hey all, > > I found a very simple macro to track any changes made to any cell in a > row by datestamping the end of the row. > The issue comes in whenever i try to insert a row into the sheet, i > get an error: "Runtime Error 1004, Application-defined or Object- > defined error" and im not sure how to fix this. > > Here is a sample of my code: > > Public Sub Worksheet_Change(ByVal Target As Range) >If Target.Column = 1 Then >Application.EnableEvents = False >Target.Offset.Offset(0, 13) = Now() >Application.EnableEvents = True >End If > End Sub > > > Could anyone please point me in the right direction, how can i keep > this functionality and still be able to insert new rows into my > sheet? > > Thanks in advance! > > Best Regards, > Pogster > > > > --~--~-~--~~~---~--~~ -- 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$$ How can a custom function know which cell its in?
Is there a way to create a custom function that will print out row number that the function is in? For example, in cell C5, I'll type '=whats_my_row_number()' and I would like it to say 5. Thank you in advance, --~--~-~--~~~---~--~~ -- 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: Auto Run Macro - Copy data from multiple workbooks
Thanks ..I've never created Windows task manager..is there a link or sample guide how to create task manager and .bat file? On Jul 17, 2:43 pm, "Daniel" wrote: > Hello. > Use the OnTime command in your macro. This means that your workbook has to > be open and your macro running at the activation time. However, if you use > Excel 2007, you could place the master workbook in a trusted folder (that is > to say that an auto open macro can run at open without security > questioning). Then, use the Windows task manager to schedule the execution > of a ".bat" file containing : > cmd /c "c:\TrustedFolder\masterfile.xls" > Hope this helps. > Daniel > > > > > -Original Message- > > From: excel-macros@googlegroups.com [mailto:excel- > > mac...@googlegroups.com] On Behalf Of TAlgo > > Sent: vendredi 17 juillet 2009 17:20 > > To: MS EXCEL AND VBA MACROS > > Subject: $$Excel-Macros$$ Auto Run Macro - Copy data from multiple > > workbooks > > > Hello, > > > Something new for me so need some help : > > > I' would like to have a macro which will extract data automatically and > daily > > from multiple workbooks ( Source ) and copy to Master workbook ( target ) > > located under same network drive. > > > Say around 5 pm EST macro should auto run and complete the above task on > > daily basis. > > > I would like to copy column A from each source files and paste to Sheet 1 > of > > Target file ( Can be in column A, B & C ) > > > Source Files > > 1) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System > > \FUTOMS-phases - eTD and TD\Reference Info\Active Users.xls > > > 2) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System > > \FUTOMS-phases - eTD and TD\Reference Info\Account Users.xls > > > 3) G:\BIT\BMProjects 2004\FUT- Futures\OMS- Order Management System > > \FUTOMS-phases - eTD and TD\Reference Info\Inactive Users.xls > > > Target File ( Master list ) > > > G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System > > \FUTOMS-phases - eTD and TD\Reference Info\eTD Users.xls > > > thx in advance --~--~-~--~~~---~--~~ -- 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$$ DateStamp Macro Debug Help
Hey all, I found a very simple macro to track any changes made to any cell in a row by datestamping the end of the row. The issue comes in whenever i try to insert a row into the sheet, i get an error: "Runtime Error 1004, Application-defined or Object- defined error" and im not sure how to fix this. Here is a sample of my code: Public Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 1 Then Application.EnableEvents = False Target.Offset.Offset(0, 13) = Now() Application.EnableEvents = True End If End Sub Could anyone please point me in the right direction, how can i keep this functionality and still be able to insert new rows into my sheet? Thanks in advance! Best Regards, Pogster --~--~-~--~~~---~--~~ -- 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: Auto Run Macro - Copy data from multiple workbooks
Hello. Use the OnTime command in your macro. This means that your workbook has to be open and your macro running at the activation time. However, if you use Excel 2007, you could place the master workbook in a trusted folder (that is to say that an auto open macro can run at open without security questioning). Then, use the Windows task manager to schedule the execution of a ".bat" file containing : cmd /c "c:\TrustedFolder\masterfile.xls" Hope this helps. Daniel > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel- > mac...@googlegroups.com] On Behalf Of TAlgo > Sent: vendredi 17 juillet 2009 17:20 > To: MS EXCEL AND VBA MACROS > Subject: $$Excel-Macros$$ Auto Run Macro - Copy data from multiple > workbooks > > > Hello, > > Something new for me so need some help : > > I' would like to have a macro which will extract data automatically and daily > from multiple workbooks ( Source ) and copy to Master workbook ( target ) > located under same network drive. > > Say around 5 pm EST macro should auto run and complete the above task on > daily basis. > > I would like to copy column A from each source files and paste to Sheet 1 of > Target file ( Can be in column A, B & C ) > > Source Files > 1) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System > \FUTOMS-phases - eTD and TD\Reference Info\Active Users.xls > > 2) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System > \FUTOMS-phases - eTD and TD\Reference Info\Account Users.xls > > 3) G:\BIT\BMProjects 2004\FUT- Futures\OMS- Order Management System > \FUTOMS-phases - eTD and TD\Reference Info\Inactive Users.xls > > Target File ( Master list ) > > G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System > \FUTOMS-phases - eTD and TD\Reference Info\eTD Users.xls > > thx in advance > > > --~--~-~--~~~---~--~~ -- 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: Auto Run Macro - Copy data from multiple workbooks
I would suggest recording a macro that does all of the things you want it to do. Call the macro auto_Open. At the end of the macro, add: Activeworkbook.close SaveChanges:=true save the workbook. Next, create a windows Scheduled task that will open this workbook at 5:00pm daily (or weekday) test it by changing the scheduled task to run a minute or two from "now". the workbook should open and run as directed and close when completed. What I have done in the past is create the macro and call it something descriptive. Then, in Auto_Open, check to see if the current workbook is from a specific path. for instance, I do the "development" and debugging in the file: \\ServerName01\project\reports\Development\Project_Summary.xls Once ready for use, I copy it to: \\ServerName01\project\reports\Batch\Project_Summary.xls Then, in Auto_Open (Or Workbook_Open) I check the file name: If (ActiveWorkbook.FullName = "\\ServerName01\project\reports\Batch\Project_Summary.xls") Then That way, I can still edit and debug the macro without it trying to run when I open the file. If you need more help with the macro itself, please record the steps and post the code. We'd be glad to look at it... Paul From: TAlgo To: MS EXCEL AND VBA MACROS Sent: Friday, July 17, 2009 11:19:45 AM Subject: $$Excel-Macros$$ Auto Run Macro - Copy data from multiple workbooks Hello, Something new for me so need some help : I' would like to have a macro which will extract data automatically and daily from multiple workbooks ( Source ) and copy to Master workbook ( target ) located under same network drive. Say around 5 pm EST macro should auto run and complete the above task on daily basis. I would like to copy column A from each source files and paste to Sheet 1 of Target file ( Can be in column A, B & C ) Source Files 1) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Active Users.xls 2) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Account Users.xls 3) G:\BIT\BMProjects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Inactive Users.xls Target File ( Master list ) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\eTD Users.xls thx in advance --~--~-~--~~~---~--~~ -- 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$$ Auto Run Macro - Copy data from multiple workbooks
Hello, Something new for me so need some help : I' would like to have a macro which will extract data automatically and daily from multiple workbooks ( Source ) and copy to Master workbook ( target ) located under same network drive. Say around 5 pm EST macro should auto run and complete the above task on daily basis. I would like to copy column A from each source files and paste to Sheet 1 of Target file ( Can be in column A, B & C ) Source Files 1) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Active Users.xls 2) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Account Users.xls 3) G:\BIT\BMProjects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\Inactive Users.xls Target File ( Master list ) G:\BIT\BM Projects 2004\FUT- Futures\OMS- Order Management System \FUTOMS-phases - eTD and TD\Reference Info\eTD Users.xls thx in advance --~--~-~--~~~---~--~~ -- 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: vLOOKUP
Use Hlookup instead On 16/07/2009, Manoj Kukrej wrote: > > hI > Can we look for fist column in **1**))>> vlookup(e3,r4:y4,1,0) > > Regards > > manoj > > -- > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *Dilip Pandey > *Sent:* Thursday, July 16, 2009 12:47 PM > *To:* excel-macros@googlegroups.com > *Subject:* $$Excel-Macros$$ Re: Creating empty rows b/w filed rows without > ASAP > > > Hi Maehsh, > > Your requirement is attached herewith. > > Thanks, > DILipandey (Back from Holidays) > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > > > > On Thu, Jul > 16, 2009 at 8:53 AM, Mahesh wrote: > > >> Hi Dilip, >> >> thanx for your prompt reply but it not working. >> >> Can you send my the xls sheet. >> >> Rgds, >> Mahesh >> >> On Wed, Jul 15, 2009 at 7:30 PM, Dilip Pandey wrote: >> >>> Hi Mahesh, >>> >>> Open the code and repeat the following line twice (i.e. one more time) as >>> it is already there in the code:- >>> >>> Selection.EntireRow.insert >>> >>> >>> Thanks >>> DILipandey (Back from Holidays) >>> -- >>> DILIP KUMAR PANDEY >>> MBA-HR,B COM(Hons.),BCA >>> Mobile: +91 9810929744 >>> dilipan...@gmail.com >>> dilipan...@yahoo.com >>> New Delhi - 110062 >>> >>> >>> On Wed, Jul 15, 2009 at 5:49 AM, Mahesh wrote: >>> Thanx, What chage should i do to insert two rows at ones. Thanx again On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey wrote: > Hi Mahesh, > > Please find the attached file with Macro. Thanks > > Dilipandey (Back from Holidays) > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > > On Wed, Jul 15, 2009 at 9:04 AM, Mahesh wrote: > >> Hi folks, >> >> Gud Morning >> >> I want insert empty row between the rows containing data with the hepl >> of macro. >> >> Please also suggested how to use it in Excel 2007. >> >> Thanks in advance... >> >> -- >> With Love, >> Mahesh Bisht >> >> > > > -- With Love, Mahesh Bisht >>> >>> >>> >>> >> >> >> -- >> With Love, >> Mahesh Bisht >> >> > > -- (¨`·.·´¨) Keep `·.¸(¨`·.·´¨) Smiling !! (¨`·.·´¨)¸.·´ Upendra Singh `·.¸.·´9910227325 --~--~-~--~~~---~--~~ -- 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: Value all the Selection
Hi, Try putting the following code in a module, then Run: Sub ChangeToValue() A = 2 Do Until Cells(A, 1) = "" Cells(A, 1) = Val(Cells(A, 1)) A = A + 1 Loop End Sub Regards - Dave Date: Thu, 16 Jul 2009 23:17:46 -0700 Subject: $$Excel-Macros$$ Value all the Selection From: deepakrawa...@gmail.com To: excel-macros@googlegroups.com Hi Dear friends I have a little querryi have attached a file and i want to use value function by macro there are some data which are not value and i want to make them value with the help of value function by macro. i am facing problem that when m making object of worksheetfunction then there is not any function of value there. Pls help!! regards, Deepak Rawat _ Looking for a place to rent, share or buy this winter? Find your next place with Ninemsn property http://a.ninemsn.com.au/b.aspx?URL=http%3A%2F%2Fninemsn%2Edomain%2Ecom%2Eau%2F%3Fs%5Fcid%3DFDMedia%3ANineMSN%5FHotmail%5FTagline&_t=774152450&_r=Domain_tagline&_m=EXT --~--~-~--~~~---~--~~ -- 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 Macros for Track Changes
Hi Pooja Yes, you are right about the disabling "Track Changes" query you raised in your earlier mail. I missed out that feature. However, you may like to check out the following sites to know more about writing a code (you can password protect the same to prevent the macro from NOT running). However, I should tell you that I have myself not yet used module mentioned here. http://www.ozgrid.com/VBA/track-changes.htm Not sure if it will help -- Ashish “If you enter this world knowing you are loved and you leave this world knowing the same, then everything that happens in between can be dealt with.” - A Quote from National Geographic Channel On 7/16/09, Pooja Sharma wrote: > > Hi Ashish, > > Thanks! for the reply. But in this case, anyone can stop the Track Changes. > This won't work as a hidden kind of thing for others. > The purpose behind this is, that whenever anyone make changes on the > worksheet(which is in shared mode) and save it, then the changes should be > highlighted in a diff. worksheet or workbook. > > Regards > Pooja > *** > > > On Thu, Jul 9, 2009 at 2:38 PM, Ashish Pradhan wrote: > >> >> Hello Pooja >> >> To track changes on a new work sheet kindly follow the steps given below. >> >> 1. Activate the Track Changes Feature. >> 2. Assume that the changes have been made and saved in the work book. >> After changes have been made to the workbook, you can automatically create a >> new worksheet that lists all the changes that have been tracked. >> 3. Open the workbook and select (Tools -- Track Changes -- Highlight >> Changes. >> 4. Change "When" tab to "All" >> 5. In the same "Highlight Changes" box, Select "List Changes on new sheet" >> and press OK. >> 6. Another worksheet called History will be automatically created in your >> workbook. This will be inserted AFTER the last worksheet in your workbook. >> 7. However, remember that if you want a history of all changes, specially >> after restarting the workbook, copy the History Sheet to another file. And >> pressing Save after you have created the History File will delete this >> sheet. You will have to repeat the process mentioned in Steps 3-5 above >> again. >> >> Important point is to make sure that you change the tab to "All" as >> mentioned in Step 4 above. (I keep forgetting that) >> >> Hope this helps. >> -- >> >> Ashish >> >> >> "Of what use is freedom if it does not include the freedom to make >> mistakes" -- Mahatma Gandhi >> >> >> >> On 7/9/09, Pooja Sharma wrote: >>> >>> 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 >>> >>> >>> >> >> >> >> >> -- >> Best Regards >> Pooja Sharma >> >> >> >> -- >> 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: Creating empty rows b/w filed rows without ASAP
Thanx dilip, my problem is solved. A learn a lot form u. rgds, Mahesh On Fri, Jul 17, 2009 at 8:42 AM, Mahesh wrote: > Hi Dili, > > Gud Morning, > > I using the same file which is already attached. > > > > > On Thu, Jul 16, 2009 at 5:42 PM, Dilip Pandey wrote: > >> Dear Mahesh, >> >> It will be good to explain, if you can share the test worksheet with us >> (having relevant data portion). >> >> Thanks >> DILipandey (Back from Holidays) >> >> -- >> DILIP KUMAR PANDEY >> MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> >> On Thu, Jul 16, 2009 at 5:15 PM, Mahesh wrote: >> >>> hi Dilip, >>> >>> I am using Excel 2007. >>> >>> >>> >>> On Thu, Jul 16, 2009 at 5:10 PM, Mahesh wrote: >>> Hi Dilip, But when i pressed up arrow the selection automatical removed for the sheet. Rgds, Mahender Bisht On Thu, Jul 16, 2009 at 4:26 PM, Dilip Pandey wrote: > Hi Mahesh, > > now do UpArrow -> means press up arrow key of your keyboard and press > CTRL + Enter. > For your convienience, entire process is explained below:- > > Select the data, leaving headings > Press F5 > Press Alt + s > Press k > Press Enter > Press Up Arrow > Press Ctrl + Enter > > Thanks & Best Regards, > DILipandey (Back from Holidays) > > -- > DILIP KUMAR PANDEY > MBA-HR,B COM(Hons.),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 110062 > Press F5 -> Alt + S -> k -> hit enter. Now do UpArrow and press Ctrl > + Enter). > > > > > On Thu, Jul 16, 2009 at 3:17 PM, Mahesh wrote: > >> Hi Dilip, >> >> What do u mean by "now do UpArrow" , unable to understand. >> >> Rgds, >> Mahender Bisht >> >> On Thu, Jul 16, 2009 at 3:04 PM, Dilip Pandey > > wrote: >> >>> *Dear Mahesh,* >>> >>> According to me, the best way is to follow the below method:- >>> >>> Select the blank region (cells), right below the data headings. >>> (Press F5 -> Alt + S -> k -> hit enter. Now do UpArrow and press Ctrl + >>> Enter). It will fill out the blank cells with the data from above row. >>> >>> If you want you can share the spreadsheet with the group as well, so >>> that we can do it and then you can check the results. >>> >>> Thanks, >>> DILipandey (Back from Holidays) >>> >>> -- >>> DILIP KUMAR PANDEY >>> MBA-HR,B COM(Hons.),BCA >>> Mobile: +91 9810929744 >>> dilipan...@gmail.com >>> dilipan...@yahoo.com >>> New Delhi - 110062 >>> >>> >>> >>> >>> >>> >>> On Thu, Jul 16, 2009 at 1:08 PM, Mahesh >>> wrote: >>> Hi, Now i also want to copy data from the above row , kindly provide the code And syntax. Thanx in advanc On Thu, Jul 16, 2009 at 12:48 PM, Mahesh < mahender.bi...@gmail.com> wrote: > Thanx bor > > > On Thu, Jul 16, 2009 at 12:47 PM, Dilip Pandey < > dilipan...@gmail.com> wrote: > >> Hi Maehsh, >> >> Your requirement is attached herewith. >> >> Thanks, >> DILipandey (Back from Holidays) >> -- >> DILIP KUMAR PANDEY >> MBA-HR,B COM(Hons.),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 110062 >> >> >> >> On Thu, Jul >> 16, 2009 at 8:53 AM, Mahesh wrote: >> >>> Hi Dilip, >>> >>> thanx for your prompt reply but it not working. >>> >>> Can you send my the xls sheet. >>> >>> Rgds, >>> Mahesh >>> >>> On Wed, Jul 15, 2009 at 7:30 PM, Dilip Pandey < >>> dilipan...@gmail.com> wrote: >>> Hi Mahesh, Open the code and repeat the following line twice (i.e. one more time) as it is already there in the code:- Selection.EntireRow.insert Thanks DILipandey (Back from Holidays) -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jul 15, 2009 at 5:49 AM, Mahesh < mahender.bi...@gmail.com> wrote: > Thanx, > > What chage should i do to insert two rows at ones. > > Thanx again > > On Wed, Jul 15, 2009 at 4:27 PM, Dilip Pandey < > di
$$Excel-Macros$$ Re: One Cell Data - Seperate to different columns
hi, just copy the data in column A1 then take the curser in another cell , then right click to curser , press paste special then select transpose then enter ok after these steps u get that data in differnt columns regards, swati On Thu, Jul 16, 2009 at 6:36 PM, TAlgo wrote: > > _ Sept. 15, down 504.48 at 10,917.51. > > > > > Hello, > > I have above data in cell A1 ..I'm looking to separate Sept 15, Down, > 504.48, 10917.51 in to different columns. > > Any idea? > > > > --~--~-~--~~~---~--~~ -- 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 -~--~~~~--~~--~--~---