• 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. W

    Re-activate active cell when userform is shown

    I have a range of cells that require the user to input data. On selecting cell to input data, a userform shows (similar to a comments box) with all the information the user would need to populate the correct data in the cell. However, once the userform shows, the focus is set to the userform...
  2. W

    Disabled Close Button

    I have unusual problems with a workbook, named DCT, that I am working on from two separate computers running two different versions of MS Excel. I have tried to find a solution on line but I'm obviously not searching for the correct thing. My work computer is running 2007 while my home...
  3. W

    Is it possible to reference a cell in a workbook saved on SkyDrive?

    Is it possible to create a reference to a cell in a workbook saved on SkyDrive without the workbook being opened? If so, how?
  4. W

    Naming a Non-Contiguous Range

    Hello All, I have written a macro to (try to) create a non-contiguous named range in a worksheet containing 10,000+ lines of data. Each of the 268 non-contiguous ranges is in column C and is 10 rows deep by 1 column wide starting at each cell containing "Process Components". The main part...
  5. W

    Changing Named Ranges

    Hello All, I am still pretty fresh when it comes to VBA so the answer to this may be simpler than I have made it so far; Sheet3 contains all the ranges that I want to add as Named Ranges. Row 1 contains the range name and everything below is the range i.e. A2:A2000 (All to be the same size...
  6. W

    Copying a table from a closed workbook

    On opening a 2007 Excel workbook, can VBA copy the contents of a table from a closed workbook located elsewhere on the server and paste it over the data in a worksheet in the opened workbook? Being a novice in VBA I can't work out if this question has been answered in another post in a...
  7. W

    Why wont Design Mode turn off?

    I have taken my first steps into VBA and and with my first attempt I've come up with a problem. My workbook is sheet and workbook protected (with column formatting allowed) to stop the numerous users destroying my formulas, formatting and print setup when entering data. Users select from a...
  8. W

    Convert text to formula

    Hello Chandoo :) Your blogs have solved many of my excel challenges over the last few years but I have come up against my first challenge that I can't find an answer to here. How do you convert a formula written as text into a working formula? e.g. I have a report producing hundreds of...
Back
Top