Replies

Thanks Wassim

I’ll give it a go.

Rob

Forgive the stupid question, but from where (or how) do you run the code? Your attachment lists no macros in the VBA window.

Regards

Rob

Can you be a bit more specific.
Why do you need to store the same data in two tables. In any case, why not set up another mail merge and use the second table as the data source?

Rob

Hi Howard
Whilst viewing your post, I was fascinated to see the word “ayup” being used. This is a common dialect word employed by the lower orders in my neck of the woods (Stoke-on-Trent, England) and other Northern England/North Midlands regions. It is frowned upon and often parodied by the gentile society of the South where it is associated with the Heathens from the North. Because it is deemed to be such a “local word”, I just did not expect to see it.

Bostin’

Rob

Hi RW Comic

Thanks for the suggestions. I’ll check them out individually.

Regards

Rob

Not wishing to stray out of my depth and appear foolish, I have a low tech solution that may serve as a temporary stopgap. When I am working on pupil records/reports or building up a stock of lessons for a scheme of work, I know that I will need to amend them before the tasks are completed. I tend to save my initial documents with a suffix appended to the filename, e.g atomsU.doc, where the U stands for unfinished. When I return and clean up I resave without the U and delete the original.
Also, it may be easier to construct a macro that would recognise the suffix.
Just a suggestion but given in good faith.

Rob

Thanks Hailey

It’s as I feared

Regards

Rob

A few questions:

Do you have the most efficient design for the task in hand?
Why would you need to insert a row above A1 or delete rows?

If you need to insert or delete rows on Sheet1 why not reinsert the formulae manually or write a macro run from a command button to automatically udate the formuale in Sheet2?

Run msconfig and look in Startup. Uncheck any references to Grau Software and reboot. The folder should then be deleteable.

Rob

Sorry Steve

I wasn’t trying to be patronising. I bow to superior wisdom!

Regards

Rob

Hi
The solution I posted results not in a line graph but in a 3-dimensional surface graph.
Regards
Rob

Thanks Legare

It works a treat.

Regards

Rob

Hi

Yes there is. John Walkenbach gives an example of a 3-D plot in his book “Microsoft Excel 2000 Formulas”. It should work in ’97.

1. Put the x values (constant increment) in the top row of a worksheet but leave the top left cell blank.
2. Put the y values in the first column (constant increment) again leaving the top left cell blank.
3. Fill the rest of the table with the formula that links x and y, that is, supply the z values e.g. z=SIN(x) + COS(y).
4. Select the entire range as the source data for the chart.

Hope that helps.

Regards

Rob

Hi Rory

I was interested in the solution you posted re: Selective Cell input. It is certainly more elegant than my effort. However, I’ve tried out the code but it doesn’t quite work. It only puts a formula (the correct one) into the active cell. It doesn’t loop through the for/next section of the code. I cannot figure out the cause. I have set rngCell to the appropriate range on the worksheet.
I’d be very greatful for your time and expertise.
I could see many useful applications of the code.

Regards

Rob

Hi kingming. Try this code:
Sub SelectiveCell()
Dim MyRangeA, MyRangeB, MyRangeC, MyRangeD As Range
Set MyRangeA = Worksheets(“Sheet3”).Range(“A1:A18”)
For x = 1 To 18
If MyRangeA.Cells(x).Value = “” Then _
GoTo LastLine Else GoTo Line1
Line1:
MyRangeA.Cells(x).Formula = “=3*2”
LastLine:
Range(“A1”).Select
Next x
End Sub

You would need to insert your own ranges and formulae in the appropriate places in the code. You would also need to add similar code for your other ranges.

Regards
Rob