Search results for query: *

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

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

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

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

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

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

Ok I need to create a flat file to upload to our peoplesoft gl database. I have all the data in one tab and I know the placement and spacing of each data point. What I need is some method to create the flat file. I thought a VBA macro could do the trick but I'm not sure how to proceed. The...

I have created a macro to copy/paste/and sort data from one sheet into another but I need to know how to write the VBA to look at the column that was just sorted and delete all Rows that have a zero in this column. Can someone please help. Thanks

Sorry for asking such an newbie question. I am trying to create a macro(VBA) that takes two cells in one worksheet and displays the result in another worksheet. The problem I am having is that when I am in the active worksheet that has the macro I just created see below: Sub Wk2() ' ' Wk2...