Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dignityy

    pop up dialog box based on date field

    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?
  2. dignityy

    pop up dialog box based on date field

    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...
  3. dignityy

    Array formula not working

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

    Array formula not working

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

    Array formula not working

    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"...
  6. dignityy

    Button disappers when macro run with no data?

    That was it, thanks Glenn.
  7. dignityy

    Button disappers when macro run with no data?

    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...
  8. dignityy

    Button disappers when macro run with no data?

    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...
  9. dignityy

    Help Make Code Faster

    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...
  10. dignityy

    Help Make Code Faster

    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...
  11. dignityy

    Help Make Code Faster

    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
  12. dignityy

    Help Make Code Faster

    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.
  13. dignityy

    Help Make Code Faster

    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...
  14. dignityy

    Help Make Code Faster

    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...
  15. dignityy

    Heres a challenge - Flate file creation

    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...
  16. dignityy

    Copy only cell range with data

    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
  17. dignityy

    Heres a challenge - Flate file creation

    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.
  18. dignityy

    Explain code

    That would make sense why it worked for me. Thanks
  19. dignityy

    Explain code

    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...
  20. dignityy

    Heres a challenge - Flate file creation

    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?

Part and Inventory Search

Back
Top