Macro help running a macro from macro

[pedro-egoli]

Some assistance please

This macro deletes all entries that are not on the half hour, and deletes date from date and time which are imported,
Works if I manually run it by clicking on bottom cell and selecting Macro/run blah.

Sub blah()
For rw = ActiveCell.Row To 4 Step -6
     Range(Cells(rw - 1, 1), Cells(rw - 5, 1)).EntireRow.Delete
Columns("A:A").NumberFormat = "[$-409]h:mm AM/PM;@"

Next rw
End Sub

I am trying to have the macro automatically run by use of this

Private Sub Worksheet_Change(ByVal Target As Range)
Set t = Target
Set r = Range("A1:A100")
If Intersect(t, r) Is Nothing Then Exit Sub
Application.EnableEvents = False
Callblah
Application.EnableEvents = True
End Sub

However, am unable to do so with the “callblah” being problem.
Once this is sorted I would like a chart to be introduced from columns A & B after original macro runs.
A holds time and B data applicable at that time.

Thanks

Pedro

 

[wigi]

There should be a space between Call and blah

 

[pedro-egoli]

Thanks for that wigi, it worked.

However, it raised another problem.

The data imported is to do with solar generation and comes from a chart which I access through inverter software linked to my computer.
It starts running early morning and does not really start producing until about 7 am.
This is the info early am that is imported

Excel Workbook
	A	B	C
1	Date	Today Energy[Wh]	*
2	03-08-11 5:26	0	*
3	03-08-11 5:31	0	*
4	03-08-11 5:36	0	*
5	03-08-11 5:41	0	*
6	03-08-11 5:46	0	*
7	03-08-11 5:51	0	*
30811

The zero production today continued to 6.51am (row 19) and apparently continues after file has been saved as when I selected the cell to delete (to run macro) it was in cell A174 (7.48PM)
This is because I need to leave inverter running so chart is not lost.
Sometimes I do the import early sometimes late.

Anyway what happens now after successfully having deletion automatic run I went back to get rid of the various cells that had continued repeating since inverter stopped producing.
This triggered the macro to run again and it deleted most of the data.

So the question at this stage is can the automatic start be limited to one run only and , if so , how do I stop the macro.

Thanks and I hope I haven't confused you too much

Pedro

 

[pedro-egoli]

Thought I had go it sorted by deleting all early morning balances with a zero and afternoon ones where numbers had been repeated.

I got the macro to run several times as I was trying to fine tune sheet and then suddenly I got a Run time error 1004 , with the line " Range(Cells(rw - 1, 1), Cells(rw - 5, 1)).EntireRow.Delete" highlighted .

To check what the problem was I stopped the debugger and the macro had in fact run and I was able to insert a chart.

However, when I repeated the same steps and went to delete a cell which had previously triggered the macro nothing happened.

Checked again with morning and afternoon balances unchanged and it worked again.

Is it one of those mysteries of life or what.

Is it possible to tweak the code which deletes rows to show only data on the half hour to also include deletion of any cell in column B with a zero as well as any times after say 5pm.
Alternatively if it could change to start 7am and finish 5 pm that would also do the job.

Present code is here

Sub blah()
For rw = ActiveCell.Row To 4 Step -6
     Range(Cells(rw - 1, 1), Cells(rw - 5, 1)).EntireRow.Delete
Columns("A:A").NumberFormat = "[$-409]h:mm AM/PM;@"

Next rw
End Sub

Thanks

Pedro

 

[pedro-egoli]

BUMP

In particular

s it possible to tweak the code which deletes rows to show only data on the half hour to also include deletion of any cell in column B with a zero as well as any times after say 5pm.
Alternatively if it could change to start 7am and finish 5 pm that would also do the job.

Pedro