provide

  1. H

    VBA code to remane shhets

    I have list of 162 names. I also have 162 sheets in workbook. I want to give name to 162 sheets from the list of 162 names. please provide VB code.
  2. A

    Recommendations for sites or books to provide a basic understanding of VBA

    Hi can anyone recommend some good sites or books for a rookie to provide a basic understanding of VBA in Excel? Any hints gratefully appreciated! Ali
  3. Y

    mandatory row values out of any three rows

    Hi Gurus, <tbody> Emp name father name mother name Guardian name James XXX XXX XXX david XXX </tbody> i have a requirement in excel, i want to save an employee details name as Jmaes i need any one of father/mother/guardian columns row value should be mandatory for this requirement...
  4. N

    Changing the size of a Check box

    I am having trouble trying to change the size of the Form Control Check Box in under the developers tab. I do not see the settings to change the size of the actual check box itself. If any one could provide some help it be greatly appreciated. Thank you in advance.
  5. S

    colored cell with negative value

    Hi First of all i am very very new to VBA and learnt some things from youtube and tried to develop a code out of that in which i expect my cells with yellow color and negative value to be multiplied by -1 after running the program but below cited isn't working could you pl look into it and...
  6. N

    Copying Check Boxes from Excel to Outlook as picture

    Good morning everyone, I would like to by saying I am currently using Ron de Bruin code: http://www.rondebruin.nl/win/s1/outlook/bmail1.htm It has failed to get the 15 check boxes and after a lot of research I have been informed that you can't keep them active. So I am looking for the exact way...
  7. P

    There must be an easier way!

    Hello, My client put together this worksheet which helps him track his investment portfolios. I made a few transaction entries myself and found the process to be counter intuitive at best. If there is an easier way I would appreciate your assistance. I can provide more info if required. Thank...
  8. I

    remove zeroes

    Dear all i want to remove the starting zeroes source 000046 000001 000123 005426 012345 876541 output must be 46 1 123 5426 12345 876451 could you please provide the formula?
  9. V

    Only Keep Rows if Columns C and D and E are NOT Blank (simultaneously), delete all others

    Hello All, I have a worksheet and I only want to keep rows that have data in columns C, D and E. If possible, I would like the search to go down to the last row of data in column A. Thanks much for any help anyone can provide.
  10. T

    New Criteria For Formula

    I've been asked to add two new additional criteria to the formula below. =IFERROR(IF((ISNUMBER(MATCH(D2,'GOSC Docs'!$A$2:$A$16,0))*(D2<>"SMILE_ERR")+(D2="SMILE_ERR")*(O2="B07")+(D2="SMILE_ERR")*(O2="B36"))*(AK2="GOSC")=1,IF(OR(P2="",P2="STR"),VLOOKUP(AF2,'GOSC...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top