Posts by kenshin

  • Remove Excessive Cell Styles

    Hello,


    I need some VBA code to delete excessive cell styles that is causing no one to be able to insert and sometimes paste new data into the file.


    I have tried to remove them manually, but for some odd reason Excel keeps telling me to unprotect the workbook even though it isn't protected. I am thus unable to remove them one by one.


    Thank you!


    #cellstyles #toomanycellformats

  • Lock & Limit Scroll Area

    Hi.


    I want users to be able to scroll top-down or sideways up to a certain point only.


    What is the VBA code to accomplish this?


    Let's say for example I want to limit scrolling from A to L rows 1 to 50 only.


    How do I do that?


    Thanks in advance!


    :grin:

  • Add Custom Menu Items Back

    Hi. In my excel application window, another application installed its for-excel toolbar. it a bunch of custom buttons.


    for some reason, some of the buttons that were there before disappeared. is there a way i can add them back to the toolbar? i tried using "customize and right-click" but the toolbar isn't among the list of options in the left window that pops up. hence, i cannot drag the buttons i want to the toolbar area. what can be done? thanks in advance.

  • Number in Cell For Row Number Formula Reference

    Hi.


    I have a bunch of row numbers listed in one column on a worksheet. I would like Excel to show me the values of the cells associated with these row numbers and a certain column.


    Example:
    1
    5
    6
    10
    33


    I would like Excel to show me what is inside cells A1, A5, A6, A10, A33 in say another
    section the workbook. For argument's sake, let the results be shown in column A, rows 50-54. What formula do I use to do this?


    Thanks.

  • Difference Between Vb And Vb.net

    Hi.


    What is the difference between VB and VB.net? I am used to programming in Excel in VB. Is VB.net used in Excel and other Office applications as well? If there was a beginner who wanted to learn how to manipulate Office applications, what would be better to learn? VB or VB.net and why? Thanks.

  • Use Range Name inside Formula

    Hi Can someone help me get this formula right.


    I have different accounts in the same folder. The formula I want to copy/fill down is the same for each row except for the name of the file/account of course. The names of the accounts are in one column. As I fill down the formula, I want Excel to lookup the account name in the matching row. I tried to use this, but Excel gives me an error:



    Code
    ='H:\Accounts\[MUM-' & B1 & 'Template FY2007.xls]MUMSY-  Sales Goal'!$AM$3


    Where B1 contains the account name.


    Thanks in advance.

  • compare two lists

    hi. i have two lists, each with the same columns, but different number of rows.


    i want to see if certain rows in one list match exactly to the other. how do i do that? i need to delete those that are duplicate.


    thanks in advance?

  • Let User Know Then Move On

    Hi. I would like my macro to process a list.


    As it processes a value, I would like it to show the user the current name on the list and then after say a 5 second delay, move on to process the next name without having the user to click/do anything.


    Can someone help me setup the code?


    I though of using a msgbox but it requires you to click on OK. That doesn't work with me.


    Thanks in advance.

  • use public variable in sub procedure

    hi. i am trying to use a public variable in different sub procedures


    This is my public variable (This_month):


    Code
    Public This_month As StringThis_month = "December"


    Then I have a sub that uses it.


    Code
    Sub repeat_me()msgbox This_monthEnd sub


    I get this error message:


    Compile error
    Invalid outside procedure


    How do I properly write the code?


    Thanks.

  • Embedded HTML Objects

    Hi. I have a macro that processes HTML pages I paste onto my worksheet. Whenever I paste the HTML contents, it brings along the drop down boxes and other stuff I don't need.


    In Excel, is there a script that goes through the entire worksheet and deletes any objects from the web? I only need the regular content that are in regular cells. I don't need all the other stuff and even the pics.


    Thanks in advance.

  • subroutine keeps stopping

    Re: subroutine keeps stopping


    hi rich


    ya it works fine now. actually it works fine at home, but not in the office. i am wondering if it is because the xl 2003 here only has sp1 installed.


    cuz it worked at home last night. i dont know what's wrong with the excel here.


    rob

  • suppress vba dialog error box

    is there a way to suppress the error dialog box?


    i already used application.displayalerts and on error resume next
    but it keeps stopping and telling me
    that code execution has been interrupted.


    i cant figure out my code and just want the computer to ignore whatever error it found.