Excel Macro help

[jjst34]

Originally posted by Epidemic
=IF(G14="Total",SUM(OFFSET(E7,-4,4):OFFSET(E7,6,4)),"")

Not sure if this does what you want but here give this a whirl.

ps this is a formula of course.

I did not generate a macro for this one.

This one sitll only sums I3:I13,,, I want it to sum up to the top #, for instance I put a # in I2,, it doesn't pick it up... You know how when you hit the AutoSum button it sums up to the very top of the #'s, even if there is 3 #'s or 5000, as long as there's no breaks... Thanks!

[Epidemic]

Mmmmmm,

a needs to be defined. wonder why? I am running 97 but systems where I have programed with office xp. hmmmmm!!!

Ok what the hell

dim a as integer above the sub line

[Epidemic]

Mmmmmm,

a needs to be defined. wonder why? I am running 97 but systems where I have programed with office xp. hmmmmm!!!

Ok what the hell

above the sub line
dim a as integer

[jjst34]

Simple solution!! Appreciate your help on that problem... I just changed it to:

Sub Find_and_delete_rows()
On Error GoTo done
Do While 1 < 1000
Cells(1, 1).EntireColumn.Find("Hello", LookIn:=xlWhole, Lookat:=xlWhole).Select
Range(ActiveCell(), ActiveCell.Offset(9, 0)).Select
Selection.EntireRow.Delete
Loop
done:
End Sub

[Epidemic]

sneaky

[jjst34]

whatever does the trick!