Search:

Type: Posts; User: Ekim; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.06 seconds.

  1. Re: Excel autogenerating email based on criteria in the shee

    Insert a standard module (VBA editor – Insert menu | Module), and copy/paste the following:


    Public Const L1 = vbCrLf ' Single line feed
    Public Const L2 = vbCrLf & vbCrLf ...
  2. Re: How to remove blank spaces from a copied webpage table

    BJungheim/huh,

    A easy way to determine the characters in a cell is to use Chip Pearson’s “Cell View” add-in. The add-in allows you to see the exact characters in a cell (including non-printable...
  3. Replies
    7
    Views
    1,285

    Re: Problem with a list box

    You can use a Validation drop down when the data is on another page providing the Validation source is a named range.

    In the other page, name your range “myRange” (whatever).
    Switch to your main...
  4. Replies
    1
    Views
    538

    Re: Question about Nimrod email code

    The above macro uses the SendMail syntax. With SendMail, it is not possible to:
    1) Send text in the Body of the mail
    2) Use the CC or BCC field
    3) Attach other files

    (source:...
  5. Replies
    1
    Views
    6,202

    Re: How to anchor a button?

    Button from the Forms menu?

    Place the button over cell G6.
    Right click the button and select Format Control | Properties tab.
    Click the radio button for “Don’t move or size with cells”
    OK.
  6. Re: Anyone know how to use the right function with macros?

    You are probably getting the following error message:
    Run-time error 5:
    Invalid procedure call or argument

    Cause:
    The range is set for A1:A20, but your actual test data is less than that i.e....
  7. Re: Excel autogenerating email based on criteria in the shee

    Dan,

    Very nice. Works like a charm.

    If I can make a suggestion – put the supplier email addresses in column J and change this line in the macro:

    .to = someone@somewhere.com

    to:
  8. Replies
    9
    Views
    1,178

    Re: What's the magic number?

    To see all Excel specifications and limitations:

    Go to the Excel Help menu.
    Type “Excel Specifications” (no quotes) in the Search box.
    Click the Search button.
  9. Replies
    11
    Views
    5,278

    Re: preserve leading zeros in CSV.. how?

    Mark,

    I just re-checked my instructions and everything worked as specified. Did you do the first three steps?

    If you open the csv file from Windows Explorer or via File | Open then I agree...
  10. Replies
    10
    Views
    1,274

    Re: Sentence Case Question

    odie,

    Macro runs OK on your data with three exceptions:

    1. There must be a period “.”, or a question mark “?” or an exclamation mark “!” at the end of the last sentence. In your example, the...
  11. Replies
    11
    Views
    5,278

    Re: preserve leading zeros in CSV.. how?

    Muffins,

    Using Excel XP

    • Open a new worksheet.
    • Go to the Data menu | Import from External Data | Import Data.
    • Navigate to your csv file, select it and then click the Open button.
    •...
  12. Replies
    10
    Views
    1,274

    Re: Sentence Case Question

    Odie,

    Please post some sample data. I have a routine that that does sentence case in Excel, including multiple sentences in a cell. However, the routine doesn’t handle people’s names. ...
  13. Replies
    7
    Views
    7,069

    Re: Run a macro to generate a drop down list

    Gidu,

    I don’t know why you are getting a run time error message .The two macros that you refer to have been re-tested, and both worked perfectly (Using Excel XP/Win 2002).

    A search of the...
  14. Replies
    5
    Views
    533

    Re: Adding 6 months to a date

    Depending on what you are doing, the formulas presented may not give you the answer that you require. For example, if you work for a dentist or a doctor and you are scheduling the next appointment...
  15. Replies
    7
    Views
    7,069

    Re: Run a macro to generate a drop down list

    First thing that I would do is to protect the worksheet to stop users moving the cells in the first place.

    Select cells A1:A10.
    Go to the Format menu | Cells | Protection tab
    Uncheck the “Lock”...
  16. Replies
    12
    Views
    3,829

    Re: subtotal at the end of printable page

    Try the following routine from Ole P. Erlandsen, http://www.erlandsendata.no/

    The macros have been amended to include a blank row between the data and the subtotals at the end of each page. The...
  17. Replies
    5
    Views
    613

    Re: Need an elapsed date/time formula!

    Brian,

    The following may work for you as you are in the US. When running the macro locally, the macro forces all my regional dates to the US format (mm/dd/yy) i.e. the Format function is...
  18. Re: Date format problem when sending file from MYOB to Excel

    Call MYOB support (assuming that you have paid support fees). You may have to upgrade MYOB to work with Office 2003.
  19. Replies
    2
    Views
    377

    Re: Hyperlinks in Workbook not playing!!!

    You will get that error message if you have spaces in your sheet names. Try this revision:

    Sub myLinks()
    SheetCount = ActiveWorkbook.Sheets.Count
    Sheets("Index Sheet").Activate...
  20. Replies
    4
    Views
    530

    Re: check box...in a cell...is it really?

    If the Checkbox (Control Toolbox menu) is covering say cell B3, and the link cell is B3 (i.e. underneath the Checkbox) then the following will work (put the macro in the relevant sheet module):

    ...
  21. Replies
    3
    Views
    512

    Re: Determine cell contents

    An easy way to determine the characters in a cell is to use Chip Pearson’s “Cell View” add-in. The add-in allows you to see the exact characters in a cell (including non-printable characters), as...
  22. Thread: Message box

    by Ekim
    Replies
    7
    Views
    523

    Re: Message box

    Same problem as previously. You have not defined “MyString” (at least it is not obvious from your code snippet that you have defined “MyString”) - just delete the reference i.e.

    Change:
    MyString...
  23. Replies
    6
    Views
    4,993

    Re: Extracting data form Reuters using VBA?

    Tanya,

    Recently on another Board, someone asked the same question as you in relation to Bloomberg. In answering the question, a Microsoft MVP advised that Bloomberg provide an XL Add-In which...
  24. Replies
    4
    Views
    7,353

    Re: Loop Macro with isText() function

    IsText is a worksheet function. To use it in VBA, prefix with Application e.g.

    Sub macro1()
    If Application.IsText(Worksheets("Sheet1").Range("A3")) Then
    MsgBox "Yes"
    Else
    MsgBox "No"
    End If
    ...
  25. Thread: Macro

    by Ekim
    Replies
    24
    Views
    1,583

    Re: Macro

    Marika,

    You need to qualify the range with the active sheet:

    Private Sub CommandButton1_Click()
    Dim lngRow As Long
    Dim Sharr(), Sh

    Sharr = Array(Sheets("Sunday Night"), Sheets("Monday...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4