Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to chart data generated in a macro in any desired sheet. Pleas
For Urgent attention please.
1. How do I plot data generated in a Function macro. Assume that I generated a data range which I need to be plotted on a sheet. I have 300 points to be plotted,say. the problem arises because I CANn't use the following command to paste data generated while running a Function. Cells(i + 10, j + 2).Value = spread(i, j) - does not work in a function ..works in a Sub. Why -- beetal |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to chart data generated in a macro in any desired sheet. Pleas
Functions return values to the cells that contain the formula. They can't
change the values in other cells. Maybe you can rewrite your function so that it returns an array and you can use a multi-cell array formula to to enter the formula. Or maybe you could a macro that you run on demand to populate the cells. Or maybe you could use some worksheet event that populates the cells. BEETAL wrote: For Urgent attention please. 1. How do I plot data generated in a Function macro. Assume that I generated a data range which I need to be plotted on a sheet. I have 300 points to be plotted,say. the problem arises because I CANn't use the following command to paste data generated while running a Function. Cells(i + 10, j + 2).Value = spread(i, j) - does not work in a function .works in a Sub. Why -- beetal -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Can I set the TAB to move only in the desired fields on sheet | Excel Worksheet Functions | |||
How to chart values generated in a macro in any desired sheet. Ple | Excel Programming | |||
Adding hyperlinks to macro-generated sheets from list of sheet nam | Excel Programming | |||
how to turn of a series in data sheet of a power point chart using macro | Excel Programming | |||
hiding all data in a sheet except desired | Excel Worksheet Functions |