1. F

    User-Defined Function Description

    I found John Walkenbach's tip on how to add argument descriptions to a user-defined function, but it does not seem to work for me. Spreadsheet Page Excel Tips: User-Defined Function Argument Descriptions In Excel 2010 After the 'description assignment macro' is run, the details become available...
  2. paliman

    VBA - Using the value of a string variable as the second argument

    Hello everyone. I have a file with several sheets, each one named after an alphanumeric account code (18D08H, 20J03, and so on) and another one named Sld2000 populated with my data. I want to put some values in each sheet, and at a certain point I need to use the value assigned to a variable...
  3. S

    Pass Input box entry as Array

    I want to allow the user to enter the name of the worksheet that they want to print with the use of an INPUT BOX. The code below works for a single worksheet; however, I want to expand the number of worksheets the user can print, and I think I want to use an array to capture the various entries...
  4. M

    Argument in a Sub Procedure

    Hello there, I searched through the questions and didn't find any question regarding arguments in sub procedures. I am trying to write a code that will require a number for a variable (i), but if no number is typed in, it will use its default value. Sub Ende(Optional Teste As Long =...
  5. I

    Function arguments

    Dear All I'm using few functions to check if the file exist into particular directory or not... IF the file exist its ok otherwise ...the program should run in the loop and check again after 10 min "Wait 600" I've used followoing functions The "Wait" function count seconds ..... The folllowing...
  6. J


    I have some questions for my midterm that is tomorrow Please Help!! Thank you! 1) Where are optional arguments always placed? 2) What are function arguments always separated by? 3)What is an example of a comparison operator? 4) what is a data marker? 5) How do you move an embedded chart to a...
  7. B

    IF function returning "TRUE"/"FALSE" literals rather than arguments entered

    I am having trouble with an Excel IF function. If I have a valid child project ID in column K (> 8 characters), then I want to use it to populate my cell. Otherwise, I want to populate my cell with the parent project ID in column J. Here is my IF statement. =IF(LEN(K2)<8,J2,K2) The result I...

Some videos you may like

This Week's Hot Topics

  • Date update overflow error ‘6’
    Dear MrExcel community, I have a project search & update & add & delete can do. There are 32 column and 5 of them is date. When I search date...
  • Highlight Row and Column on cell selection
    In the following I have some code I need modified to see if I can do the following: 1) Only have this work when selecting a cell inside a couple...
  • Need Numbers Inputted and Deleted
    Thanks for your help. Not sure if there is even an = equation for this. Please see attachment. If there is a solution, please respond with = So...
  • Worksheets(x).Select Error
    Hi, I am trying to select multiple sheets using the following code. [CODE=vba] Dim x As Integer ThisWorkbook.Worksheets(3).Select...
  • myFind Range not working
    Please can someone say why this myFindRng goes red in the code? [CODE=vba]Private Sub Model_Chose_Change() With ThisWorkbook.Worksheets("Job...
  • How to identify the last page break in a sheet
    How can I find the position of the last page break in my sheet? There may be multiple pages and I want to know how to find the position of the...

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
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 "".
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