Search results for query: *

Skip - I want a more automated event to occur. When ever someone opens the file the macro should run(or via button) and then the macro will check the date column for each row against the system date and open up a dialog box indicating which row needs attention. Can you help?

I have another question I hope someone can help me with. I have a data base stored in excel and when the date field expires I want a dialog box to pop open indicating so, is this possible? For example we have a date in column E and when that date comes I want a dialog box to open up and tell...

Thanks that fixed the issue! Just for learning sake do you guys know what was wrong with my original Array formula? Thankyou

I get a compile error when using that code that says x is not definted? Doesn't "For x = 1 to 12" define it?

Here is the code: Sub ClearDownloadAndPeriodTabs() ' ' ClearDownloadAndPeriodTabs Macro ' Macro recorded 10/17/2006 Application.ScreenUpdating = False Sheets("FRx Download").Rows("2:3000").ClearContents Sheets(Array("P1", "P2", "P3", "P4", "P5", "P6", "P7", "P8", "P9", "P10", "P11"...

That was it, thanks Glenn.

Skip, To answer your first question I am not sure what the WITH is refering to, Loomah from this forum offered that entire delete code section to assist me in deleting all rows that had a zero balance. No where else in the code does the with appear. I actually am now curious what it means...

Ok here is a strange occurance I need some help with. When I run the following code with no data in the source tabs (yes it makes no sense to run with no data but anyway) my macro button is deleted off the page? This does not happen if the code is run with data. Here is a summary of the code...

Loomah, Yes all the DoItAll's are working from the same workbook. Your suggestion of adding .Activate worked. We are right in the middle of uploading our budget using new software and you helped me out big time. Thanks for taking the time, very much appreciated. Oh and actually your new code...

Loomah, Forget my last question, your code works awesome, took the processing time from 15 minutes to 15 seconds, most impressive! Your code works great if I run each month independently but when I run the main macro: Sub RunAll() DoItAll1 DoItAll2 DoItAll3 DoItAll4 DoItAll5 DoItAll6 DoItAll7...

Loomah, One quick question though, I only want the delete function to look at column "F" ($ column) for zero values? Does your code currently look at any column? The problem is that I have text columns "A" & "B", account numbers in columns "C" through "E" and $'s in column "F". Thanks

Thanks alot for the great responses, I need some time to implement them. I did however start playing around with using the filter function as an alternative to using the delete code which obviously saved tons of time. Loomah I will try your code out today... thanks for taking the time.

Thanks Hugh I will make those changes and let you know the time difference. Loomah, Thanks for your suggestions as well, and yes I need to copy past special. With the delete rows function I need to delete all rows in column D that are zero, is there a better way to accomplish this? And if I...

I have written the following procedure to copy/sort & delete all the zero rows, the problem is that it takes over a minute to run this code. This is compounded by the fact that I have this same macro for each month of the year and when I run my main macro which runs all 12 months consecutively...

Bong, Here is the layout by position and length location(ie between each position are blank spaces) 1 code length = 1 2 company - length = 5 7 ledger - length = 9 26 account - length = 10 46 department - length = 10 173 year length - budget period 177 period length - 1 208 $ length - 20 That...

I have a macro that copied data to a new sheet and now I want the next part of the macro to highlight and copy only the cell range that has data in at least one of the columns. thanks

Bong, looks like I have some thinking to do... I'm a little to new right now to fully understand how to write the code you are talking about but learning more everyday.

That would make sense why it worked for me. Thanks

Can someone give a row by row explantion of how this code functions: Dim i As Integer i = 1 While Cells(i, 4) <> "" Cells(i, 4).Select If Cells(i, 4) = 0 Then Rows(i).Delete Else i = i + 1 End If Range("F1").Select Wend Obviously the goal is delete rows...

The data is currently in excel seperated in seperate cells. Bong, Can I somehow set the spacing to each data point, for example if the $ start in data point 135 how do I write a macro for that?