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!
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...
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(...
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
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...
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!
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...
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 =...
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...
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
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!
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...