Programming

MACRO TO COUNT ALL OPEN WORKBOOKS and print
I need to know if there is a way i can run a macro to count all open workbooks and print "sheet1" of all open workbooks. The macro should close each workbook after printing the first sheet. ... 11 May 2010 14:33

require cell input before macro can run
I have a macro that runs from a textbox click. I would like to require a cell (say b19) have data entered in it before the macro can run. I am having issues with folks running the macro before all of the data is entered. ... 11 May 2010 13:25

AdvancedFilter property?
I need a way to clear any and all AdvancedFilter on a worksheet so that all rows are displayed. I've tried the ShowAllData method and it works fine as long as there are filtered rows on the sheet. But the method fails if there are no filtered rows. Is there a way ShowAllData regardless of whether rows are fi... 12 May 2010 00:30

FOR EACH NEXT Multithreaded !
Hi all !! just a post to spend some time probably... where should i post a comment to suggest to Microsoft to develop this kind of element...: the FOR EACH NEXT Multithreaded .. i think it's the most important thing in vbe, that should have big benefit from multithreading and i don't think that it would ... 11 May 2010 11:11

Can not show scrollbars using listview on a userform
Hi all. I have an userform where I need to show several lines of a sheet. I'm trying to use a listview control, instead of a listbox, since the appearance of the listview, for the user, is far way better than the listbox. But I encountered a serious problem: the listview does not show the scrollbars, both th... 11 May 2010 11:11

Vlookup
I would like to flag a cell with an A for active or I for inactve (lets say cell A1) and based on the entry have another cell (G1) populate an entry from another worksheet. =IF(ISERROR(VLOOKUP(A7,'EQN''s'!$A$1:$B$2048,2,FALSE)),"",VLOOKUP(A7,'EQN''s'!$A$1:$B$2048,2,FALSE)) The catch being that it will be dyn... 11 May 2010 10:04

if else if...
hello all!! any reason why this should not work correctly ? ;))) tx !!! If aWS.Range("M52").Value = True Then aWS.Range("M80").Value = 5 Else If aWS.Range("M51").Value = True Then aWS.Range("M80").Value = 4 Else If aWS.Range("M50").Value = True Then aWS.Range("M80").Value = 3 Else If aWS.Range("M49").Va... 11 May 2010 11:11

How to close excel worksheet after 15 mins? once it opened
I am using Excel 2003. Once I open a workbook, I would like to close it after 15 mins automatically. Does anyone have any suggestions on how to code it in macro? Thanks in advance for any suggestions Eric ... 11 May 2010 21:15

Comment in every 10 the row
Hi Can anybody help in making a VBA I have column “A” and “B” and I need a comment "AUDIT"in column “C” at every 11 row of column “C”. I have tried the below but does not work Sub MyMacro() Dim lngRow As Long For lngRow = 11 To Cells(Rows.Count, "D").End(xlUp).Row Step 11 If Range("D" & lngRow).Comment Is... 11 May 2010 12:18

Conditional formating of cells
Good afternoon, I have an array of numbers in excel. I want then to display as percentage if I've selected "proportional" from a drop down menu. I want them to display as a number (0.00 for example) if I select "absolute" these are the only two options in the menu. I'ved tried using the Format code help i... 11 May 2010 08:57