Re: $$Excel-Macros$$ Re: Exrtact only numbers.
Thank you... Thanx a lot dude... Regards, Jay S On Wed, Jun 30, 2010 at 5:06 PM, devi prasadc devi.pras...@gmail.comwrote: Hi Jay, I could get solutions for couple of things only. Regards DeviPrasad On Wed, Jun 30, 2010 at 4:03 PM, lucky singh lucky60...@gmail.com wrote: 4 variours formulas reuired... sample attached along... Regards, Jay S On Wed, Jun 30, 2010 at 3:21 AM, r robb@gmail.com wrote: On 29 Giu, 12:05, lucky singh lucky60...@gmail.com wrote: Hi All, 1. I want to extract all the numbers 2. I want to trim only the middle name Regards, Jay S Nadine.xls 18KVisualizzaScarica can you give an example of the result you want Regards r -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Macro to shade every other row
On 30 Jun. Kurt wrote: 1. The comment in this code has as an example, ShadeAlternateRows Range(A1:D50), 27, 2, but where in the actual code do you put this information? Stuart Redmann wrote: That depends on when the highlighting should happen. Kurt wrote: I'm most interested in learning how to do it manually (e.g., after manually selecting a range). Ok. First of all, you can only use subs that take no arguments (and then it does not matter where you put it). The macro must be re- designed to use the current selection (also we have to fix the step width and the color): Public Sub ShadeAlternateRows() With Selection ' remove any previous shading .Interior.ColorIndex = xlColorIndexNone ' Shade every second row in yellow (= color index 27) Dim r As Long For r = 2 To .Rows.Count Step 2 .Rows(r).Interior.ColorIndex = 27 Next r End With End Sub Now you this sub appears in the macro list and can be assigned a shortcut. If you need to be able to use different colors, you'll have to pop up a dialog that lets the user choose a color. Regards, Stuart -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Keywords from QuickBasic to VBA
I use to program in QBASIC and QuickBasic some 15 years ago. There is a book called The Revolutionary Guide to QBASIC from WROX. There is lot you can use to convert to VB or VBA. On Jun 30, 5:51 am, mikeb mb...@allstate.com wrote: Hi Paul, I was referred by Dave Bonallak, I would appreciate any help you can give. I have a very old program written in QuickBasic 4.5 which does a lot of statistics and printing the results in colorful graphic charts. I could use a lot of what this program does, however being a DOS program isn’t very friendly, so I thought maybe I could convert parts, it is very modular, to VBA and was wondering if you know a source where I can find a list of QuickBasic Keywords that have been correlated to their counterpart in VBA. If you have time and can respond I would appreciate your help. Thank you, MikeB -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Keywords from QuickBasic to VBA
Thank you for your help and direction Tomaz! The Best MikeB On Jul 1, 3:51 am, Tomaz tomaz.sil...@gmail.com wrote: I use to program in QBASIC and QuickBasic some 15 years ago. There is a book called The Revolutionary Guide to QBASIC from WROX. There is lot you can use to convert to VB or VBA. On Jun 30, 5:51 am, mikeb mb...@allstate.com wrote: Hi Paul, I was referred by Dave Bonallak, I would appreciate any help you can give. I have a very old program written in QuickBasic 4.5 which does a lot of statistics and printing the results in colorful graphic charts. I could use a lot of what this program does, however being a DOS program isn’t very friendly, so I thought maybe I could convert parts, it is very modular, to VBA and was wondering if you know a source where I can find a list of QuickBasic Keywords that have been correlated to their counterpart in VBA. If you have time and can respond I would appreciate your help. Thank you, MikeB- Hide quoted text - - Show quoted text - -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Keywords from QuickBasic to VBA
As one who tries to convert code from old programs to new, here is my experience. If you are switching to Excel with VBA macros the inputs and outputs become different. You can now set up a spread sheet for inputing data. Since the data is visible you don't need to run a sub routine to check your inputs unless there are specifc constaints that don't work.I use cells().value a lot. On Jun 30, 7:51 am, mikeb mb...@allstate.com wrote: Hi Paul, I was referred by Dave Bonallak, I would appreciate any help you can give. I have a very old program written in QuickBasic 4.5 which does a lot of statistics and printing the results in colorful graphic charts. I could use a lot of what this program does, however being a DOS program isn’t very friendly, so I thought maybe I could convert parts, it is very modular, to VBA and was wondering if you know a source where I can find a list of QuickBasic Keywords that have been correlated to their counterpart in VBA. If you have time and can respond I would appreciate your help. Thank you, MikeB -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Macro to shade every other row
You are a hero! Works perfectly. Let this code replace the 400 other, more complicated examples of code I found that attempt to do the same thing. On Jul 1, 2:34 am, Stuart Redmann dertop...@web.de wrote: On 30 Jun. Kurt wrote: 1. The comment in this code has as an example, ShadeAlternateRows Range(A1:D50), 27, 2, but where in the actual code do you put this information? Stuart Redmann wrote: That depends on when the highlighting should happen. Kurt wrote: I'm most interested in learning how to do it manually (e.g., after manually selecting a range). Ok. First of all, you can only use subs that take no arguments (and then it does not matter where you put it). The macro must be re- designed to use the current selection (also we have to fix the step width and the color): Public Sub ShadeAlternateRows() With Selection ' remove any previous shading .Interior.ColorIndex = xlColorIndexNone ' Shade every second row in yellow (= color index 27) Dim r As Long For r = 2 To .Rows.Count Step 2 .Rows(r).Interior.ColorIndex = 27 Next r End With End Sub Now you this sub appears in the macro list and can be assigned a shortcut. If you need to be able to use different colors, you'll have to pop up a dialog that lets the user choose a color. Regards, Stuart -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Hi, need your help - urgent
Hi Rajender, I am not quite sure how would you want to do it. However there is a very simple solution mentioned in the link below, which almost does what you are trying to achieve. http://www.excelforum.com/excel-general/713781-display-an-image-based-on-a-cells-value.html http://www.excelforum.com/excel-general/713781-display-an-image-based-on-a-cells-value.html Regards, Andy On Thu, Jul 1, 2010 at 5:44 PM, Rajender Soni soni.rajen...@gmail.comwrote: Hi Pls find attached the excel file, I just want that when I move my mouse cursor over a cell, the image having the name equal to cell's value will get displayed, pls open the attached excel file for more clarification. Regards Rajender Soni -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Hi, need your help - urgent
hi i need help how i can secure a hidden sheet no any one can unhide and modify it. Regards Ni On Thu, Jul 1, 2010 at 7:38 AM, ashish koul koul.ash...@gmail.com wrote: hi Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If ActiveCell.Row = 2 And ActiveCell.Column = 1 Then Call deletshape Sheets(Sheet1).Select Range(E9).Select Selection.Delete Sheets(2).Shapes(1).Copy Sheets(Sheet1).Select Range(E9).Select ActiveSheet.Paste ElseIf ActiveCell.Row = 3 And ActiveCell.Column = 1 Then Call deletshape Sheets(2).Shapes(2).Copy Sheets(Sheet1).Select Range(E9).Select ActiveSheet.Paste ElseIf ActiveCell.Row = 4 And ActiveCell.Column = 1 Then Call deletshape Sheets(2).Shapes(3).Copy Sheets(Sheet1).Select Range(E9).Select ActiveSheet.Paste ElseIf ActiveCell.Row = 5 And ActiveCell.Column = 1 Then Call deletshape Sheets(2).Shapes(4).Copy Sheets(Sheet1).Select Range(E9).Select ActiveSheet.Paste End If End Sub Sub deletshape() Dim sh As Shape For Each sh In Sheets(1).Shapes If sh.Type = msoPicture Then sh.Delete End If Next sh End Sub ashish koul akoul.blogspot.com On Thu, Jul 1, 2010 at 5:44 PM, Rajender Soni soni.rajen...@gmail.comwrote: Hi Pls find attached the excel file, I just want that when I move my mouse cursor over a cell, the image having the name equal to cell's value will get displayed, pls open the attached excel file for more clarification. Regards Rajender Soni -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- Kindly Regards Nifaz Islam -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ How to increase size and color of text in user form ?
Dear Group , How to increase size and color of text in user form ? Thanks, Worawat -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Appending student data from multiple sheets in Chronological order
Hi Excel Programmers: Described here is the functionality that staff at a small school would like added to an Excel app for tracking student grades and progress. Any coding help would be greatly appreciated!! Here are the workbook’s parts: There is a sheet named “Students” in which last and first names of students are imported into cols A and B. On this sheet are also two Microsoft Date Time Picker controls for selecting starting and ending report dates. There are 7 worksheets named Period 1, Period 2,…, Period 7 (for 7 different school classes). A student may be entered in just one of the periods, may be in 3 periods, all 7 periods, whatever. If they're in multiple periods, students are Not necessarily entered on the same rows. A worksheet named “Progress Report Template” is in the workbook to be used for reports. Here is the basic setup of the 7 worksheets named Period 1, Period 2, …, Period 7: Last and first names of students are in columns B and C on every ODD row, starting on row 13. Dates are inserted in row 12; each day’s date is in a separate column. There are other headings along this row, not just dates, but the date columns are entered consecutively. Comments about a student’s work that period are typed in the date columns, but 1 row Below which the student’s names have been inserted (so the comments are on every EVEN row). Here is the desired functionality: Teachers would like to go to the sheet named “Students,” select starting and ending dates from the Microsoft Date Time Picker controls (E3 and E5), click a blank cell next to a student’s name (to select that student to report on), say, a cell in col D, and then have Excel do the following: 1. Store the last and first names of the student from cols A and B as variables. 2. Store the starting and ending dates from E3 and E5. 3. Create a copy of the worksheet named “Progress Report Template” in the workbook. 4. Rename the copy of “Progress Report Template” with the student’s first and last names. 5. In the student’s new report worksheet, input his/her last name in cell B1 and his/her first name in B2. 6. In the student’s new report worksheet, insert the starting date in B6 (or a row below any existing data). 7. Here’s the crazy part – scan Period 1 for the student’s last and first names (would be in cols B and C on the Period sheets). If found, do the following: 8. Copy the typed comment (if any) in the cell at the intersection of 1 row below the student’s names (cols B and C) and the column with the date heading in row 12 that matches the starting date. 9. Return to the student’s report worksheet and insert the starting date in cell B6 and the corresponding comment in cell C6 (or a row below existing data). 10. Then, go to and scan Period 2 and do the same if the student is present—copy the comment at the intersection of 1 row below the student’s names and the column with the matching date in row 12, return to the student’s report worksheet and insert the date and comment [a row below the previously used row]. 11. Repeat this for each Period’s sheet. 12. AND—for a range of dates (from the Microsoft Date and Time Pickers in the Student’s sheet)—repeat this for the next consecutive date— scanning the Period worksheets, copying the comments for the students on those days, then copying and listing them on the student’s report sheet. 13. Lastly, set the newly inserted dates and corresponding comments as the new print range (everything above row 5 will be the page’s heading). Don’t want very much do we? Does this make sense? I realize this is very complex. Again, any help on this would be super appreciated. Thanks. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Data Extraction from Database.
Awaiting for response. On Tue, Jun 29, 2010 at 2:47 PM, Chandra Gupt Kumar kumar.bemlmum...@gmail.com wrote: I am looking to extract data from a large database based on specified criteria. Further, there is need to sort the data based on date criteria. Attached sample data file for your consideration. Please use other than data filter criteria and also let me know whether it is possible to accomplished with Macro or not ? Regards, C.G.Kumar -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
Re: $$Excel-Macros$$ Trim first 8 characters off a cell
You can use Mid formulae. By the way you are On Mon, Jun 28, 2010 at 10:25 PM, Nadine S n8dine4ma...@yahoo.com wrote: I have a cell that I'd like to write a formula that returns all but the first 8 characters. The cell's data can be any length. Thanks. Nadine -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
RE: $$Excel-Macros$$ Trim first 8 characters off a cell
=Right(A1,LEN(A1)-8) Regards - Dave. Date: Fri, 2 Jul 2010 09:40:24 +0530 Subject: Re: $$Excel-Macros$$ Trim first 8 characters off a cell From: kumar.bemlmum...@gmail.com To: excel-macros@googlegroups.com You can use Mid formulae. By the way you are On Mon, Jun 28, 2010 at 10:25 PM, Nadine S n8dine4ma...@yahoo.com wrote: I have a cell that I'd like to write a formula that returns all but the first 8 characters. The cell's data can be any length. Thanks. Nadine -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _ Need a new place to live? Find it on Domain.com.au http://clk.atdmt.com/NMN/go/157631292/direct/01/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
$$Excel-Macros$$ Re: Hi, need your help - urgent
Hi Thanks for the help, In this I want that if the user can increase or decrease the size of the image, it will change, but next time when the image gets loaded it should have its original dimensions, the image should live within the cell, should not go beyond the cell's dimensions. Regards Rajender Soni On Jul 1, 5:14 pm, Rajender Soni soni.rajen...@gmail.com wrote: Hi Pls find attached the excel file, I just want that when I move my mouse cursor over a cell, the image having the name equal to cell's value will get displayed, pls open the attached excel file for more clarification. Regards Rajender Soni image.xlsx 168KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe