How can I avoid copy & paste of cells with conditional formatting to mess up and extend the rules list when pasting? I copy a cell with conditional...

i have a workbook made up of about 50 worksheets with same column headers but different row counts. In sheet one is a handfull of user names that could be...

old-time MS user and love keyboard controls. Some seem to be lost to us in MS-7

I am needing some help with this vba code. What I am trying to do is first verify if cell A4 is not empty, if it is not empty then I need it to make sure...

Doing a timesheet application, how to I add up the hours when they exceed 24 hours? The same issue would come up in a project management application when the...

Basically i have done a Album and Singles chart and i would like to insert a find button so it can find a sond or album when you type it in i understand you...

Hi all, Does anyone know why the command ActiveWindow.DisplayWorkbookTabs = True or ActiveWindow.DisplayWorkbookTabs = False anywhere in an activeworkbook...

I have a column A where i have the State names. A second column with a number. I need to be able to use formulas that give me the Max number per State. The...

HTE is an acronym I use frequently and it won't let me put it in a call without converting it to the article "THE"

I'm trying to get the average of the absolute values of a set of data over 8 weeks. Each week is on a seaparate sheet so to capture the moving ranges I've...

Dear sir Please clarify the take Print in Excell sheet odd number and even page Regards M.Dhanasekar

I have used the workday function to populate column A with just workdays (also used a named list of holidays to exclude). I was wondering if anyone had a bit...

I am trying to insert a 'hyperlink' into a spreadsheet. The URL I'm using is: http://www.fedex.com/Tracking?cntry_code=us and I would like Excel to add the...

I have a column of cells that contain part names and descriptions. The descriptions are multi-lined within the cell via line feeds of Alt+Enter. I would like...

Hi, I have a list of emails in a column but many of them have a space at the end of the email address. I need to be able to remove the space and then run an...

Hi, I have a column of fields with some duplications. I want to remove those duplications but all of the duplicates have a space at the end of them so are...

I'm manipulating rows, and I want to know if I can distinguish between rows that have been hidden, and rows that have been set to RowHeight = 0. Thanks M

Hi! I am trying to create a league table suing quite a lot of data. Scenario: I have 20 shops who each use on average 25 intermediaries. I have obtained the...

Hi. I have a workbook in Excel 2007 with several phone numbers. If the numbers are duplicated I applied a conditional formatting so as to display them in...