Replies

I need to use formulas as this is a small part of a bigger project and i need it to “automatically” take out the zeros. Is there a set of formulas i can use to get rid of them? thanks

very cool. thanks!

very cool. thanks!

Hi Hans,

Thank you very much. That works great! Now i realize i want to delete the cells that are NOT in COL A, that have text. How do i write a function that is like

Function IsText(oCell As Range) As Boolean
IsText = code to see if the cell has text in it
End Function

so i can delete those rows as well. Thanks

Hi Hans,

Thank you very much. That works great! Now i realize i want to delete the cells that are NOT in COL A, that have text. How do i write a function that is like

Function IsText(oCell As Range) As Boolean
IsText = code to see if the cell has text in it
End Function

so i can delete those rows as well. Thanks

so u missed me macropod well, i’ve been playing poker lately and need the formula to decide when to raise!!!

so u missed me macropod well, i’ve been playing poker lately and need the formula to decide when to raise!!!

thank u all very much

thank u all very much

yep, that will do it. Thanks so much

yep, that will do it. Thanks so much

i changed it to activesheet.range(“B4”) and that works. the cmd button is on the same sheet as where i want the filename B4 to be places.

It works now. Thank you so much for the help.

i changed it to activesheet.range(“B4”) and that works. the cmd button is on the same sheet as where i want the filename B4 to be places.

It works now. Thank you so much for the help.

I tried that and i get “Code execution has been interrupted”

The code resumes execution if i press F8 in the IDE but i think the problem has to do when i have the view of the folder contents, i choose a file and double-click on it and then i get the error.

It has something to do with double-clicking on the file. I don’t know how else to “choose” it. thank u for the help.

I tried that and i get “Code execution has been interrupted”

The code resumes execution if i press F8 in the IDE but i think the problem has to do when i have the view of the folder contents, i choose a file and double-click on it and then i get the error.

It has something to do with double-clicking on the file. I don’t know how else to “choose” it. thank u for the help.