$$Excel-Macros$$ Re: vba to close workbook if last row with data = 10

2009-11-09 Thread PauloBR
Good Morning Dellosa, How many rows and columns do you have in your sheet? Please, give us more information about your problem... Best Regards On 9 nov, 02:31, OSAVentures Calamba wrote: > dear gurus, > > i need to close a workbook if last row with data =10,  Any VBA suggestion > please? > >

$$Excel-Macros$$ Re: Excel Formula

2009-09-16 Thread PauloBR
Thanks Paul for your help! I fixed the problem only putting "Application.Calculation = xlCalculationManual" in the begin of the procedure. Now, I'll try your suggestion.. Best Regards Paulo --~--~-~--~~~---~--~~ -

$$Excel-Macros$$ Excel Formula

2009-09-15 Thread PauloBR
Hello All! How are you? I hope fine! I need your help, please. I'm writing a formula into a cell by a VBA Code: ActiveCell.Value = " = COUNTBLANK(" & CStr(RefEdit1.Value) & ")" So, when I run this code, that cell returns "#NAME". I just open the cell value to edit (but I edit anything) and say