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

    Copy values from an entire sheet into a different sheet

    Hi I get this error now Runtime error '1004' To paste all cells from an excel worksheet into the current worksheet, you must paste into first cell (A1 or R1C1) Thanks again!
  2. S

    Copy values from an entire sheet into a different sheet

    Hi I seem to be having some problems with basic 'copy-paste'! I need to copy values from 'Sheet1' to 'Sheet2' (thats all really!). Sub copypaste() Worksheets("Sheet2").Cells.Value = Worksheets("Sheet1").Cells.Value End Sub I get a 'Run-time error '7': Out of memory' error message...
  3. S

    Calculate nearest quarter end with date and month 4 financial year end as input

    Thanks a lot LukeM and SirJB7! so much appreciated :)
  4. S

    Calculate nearest quarter end with date and month 4 financial year end as input

    Hi, I am trying to calculate the quarter end date for a given date, with month for financial year end as input. Ex: Input date - 21/05/2013 (Cell A1) Input Month for financial year end - 8 (august) (Cell B1) Result should be: 31/05/2013 I tried using this formula - EOMONTH( DATE( YEAR(...
  5. S

    Recommend a good book for VBA for beginners

    Hi, I am looking to learn some basic / beginner macro coding. Can you please refer to some good books please? I live in London, so books available from uk-based sellers will be most appreciated :) Thanks, Yerr
  6. S

    Development and Operations Period charts

    Hi, I am trying to create a development and operations period chart to show the revenue, expenses and interest paid in one chart. The chart will have to plot following on primary axis: revenue (Item 1) as a column graph, expenditure (Item 2 and Item 3) also as a column graph and interest...
  7. S

    Prevent macro from rounding numbers

    Thanks Luke. The info will only move around with inserting / deleting cells. So I named my origin and destination cells as 'Copy' and 'Paste', and it seems to have done the trick. thanks a ton again!
  8. S

    Prevent macro from rounding numbers

    Thanks Luke. The cell from where it was being copies was formatted as 'Currency'. When I changed the formatting to General, this error disappeared! Also, is there a way for the macro to be dynamic - example, in my workbook, I move some information around and hence the cells from wher i have...
  9. S

    Prevent macro from rounding numbers

    Hi, I am using a simple one line macro to copy value from one range to another. Problem is that the macro seems to be rounding the numbers to 2 decimal places, while I want no rounding. The code i am using is: Sub Sens1() Worksheets("Dashboard").Range("I26:I38").Value =...
  10. S

    Allow only one checkbox to be selected at a time

    Thanks Luke, you are a star! If i can be a little more painful, is there any way to link the text / name of the option box to a cell please? I have a dynamic list which displays top three names sorted according to the values, and I then use this for graphs. So if the option button name can...
  11. S

    Allow only one checkbox to be selected at a time

    Hi Is there any way to allow only one checkbox to be selected at a time? I have 3 checkboxes for 3 names (AA, BB, CC) and I need to enable the user to select only one at a time. If AA is selected, then BB and CC should be automatically cleared. Thanks very much in advance! Yerram
  12. S

    Copy the address of an external link as text into another cell

    Thanks all for the responses! I used Luke M UDF and sorted it out. Hui, thanks for the intro. I am not very sure I understood your suggestion - Is Get.Formula an inbuilt macro command in excel? and is that the case for ExtractLink as well? Cheers!
  13. S

    Copy the address of an external link as text into another cell

    works like a charm! thanks so much do you think there is anyway to do this without UDF? Thanks a ton!
  14. S

    Copy the address of an external link as text into another cell

    Hi, I am trying to copy the address of an external link (not a hyperlink, an external link to a different workbook) as a text string into another cell. Example: The filename I am working on is called 'Try'. Say cell Sheet1!A1 has this formula: ='[Book2.xls]Sheet1'!A1 which has a value of 5...
Back
Top