Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. keywordmonkey

    Rolling out the same personal workbook to a team

    Hi I need to rollout the same personal macro workbook to a number of users. My current approach is to have each user run an install programme once that extracts the file to the diretory it needs to be in: C:\Documents and Settings\USERNAME\Application Data\Microsoft\Excel\XLSTART They can...
  2. keywordmonkey

    Problems with Excel macros on multiple machines

    Hopefully somebody has come across this problem deploying macros on multiple PCs. I've got a macro that runs fine on a colleague's PC. But on mine (same OS, same Excel version and service pack) it runs differently - namely it doesn't paste some data from sheet1 to sheet2. I suspect there is a...
  3. keywordmonkey

    Permanetly building macros into Excel

    Hi I need to build a number of macros into Excel permanently for a number of users to use for any spreadsheet, so they can access them via a button on the toolbar and/or menu item. However, I need to do this without storing the macros in spreadsheet if possible. So is there a way to build...
  4. keywordmonkey

    Public holidays dates add in for Outlook

    Hi All Has anybody come across a free/low cost add-in which automatically updates the Outlook calendar with official public holidays? I need this for the US, and major EU countries. I couldn't find one on microsoft.com, but I may have missed it...
  5. keywordmonkey

    Filling down for as long as cells in another column are full

    Hi I've been trying to write code that will fill down a formula in F1. It needs to fill down for the same number of cells that have values in Column C. So if there were values in C1-C256, the formula would automatically fill down in F1-F256. I know it needs an IF argument but I don't have...
  6. keywordmonkey

    Excel: Removing spaces at the start and / or end of text in cells

    Hi I've got lots of sheets with text in cell A that has spaces at the start/end/both, of the text. Currently I can remove this by pasting into Word, justifying into the centre, to the right and then to the left (the only clumsy solution I've found). I'd like to either use a macro to do this...
  7. keywordmonkey

    Excel: changing text colour when a character length is exceeded

    I want to be able to automatically change the text colour to red if the user types more than a set number of characters (including spaces). So if I set the limit was 75 for D1, I'd want the text to go red if they typed 80. I've seen this done, I think without a macro, and can't find any data...
  8. keywordmonkey

    Removing multiple HTML links across rows

    Is there an easy way to remove all the hyperlinks in a sheet in one easy go without cutting and pasting the column into notepad? I know how to remove individual links, but can't find anything about cleaning away all the links in one easy go, so I guess code is required. Suggestions anyone?
  9. keywordmonkey

    Com,apring sheet1 to sheet2 & outputing to sheet3

    Hi I'm new to VBA programing and don't know where to start with code to do this: User has pasted old values on spreadsheet1, and new values onto sheet2. 1) Need a macro that: - compares contents of each row on sheet2 column A, to sheet1 column A (not case sensitive) - if the contents of a...

Part and Inventory Search

Back
Top