• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Reset Button changing only non-blank cells in a range

    Narayan: This is generating the following error: Run-time error '1004' No cells were found. The populated cells will have three choices other than "Status (Choose):" from a pull down (via data validation). The form is to be reused each month, with the reset button returning the pull down...
  2. J

    Reset Button changing only non-blank cells in a range

    I'd like to put a reset button into a spreadsheet so that I can reset the value of certain cells in a range at the start of a new payment cycle. Here is the code I have so far: Private Sub CommandButton1_Click() Range("U:U") = "STATUS (CHOOSE):" End Sub Unfortunately there are a lot of...
  3. J

    How to set print area on multiple sheets in Excel 2007

    I need the help of the talented folks on this board. I've got a spreadsheet with 86 identical sheets, but the print area is off on each. When you select multiple sheets the Print Area button grays out. So looks like a job for VBA, however, my VBA skills are limited to copying snippets off the...
Back
Top