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!
-
Congratulations SkipVought 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: *
- Users: PhilipAyres
- Order by date
-
How do I create an Add In ?
How about: activeworkbook.activesheet.Cells(lRow, 5).Formula = "=(C" & lRow & "/10)*D" & lRow That should force XL to use the right sheet - I always preface the cells statement where there is the remotest chance xl can get confused !- PhilipAyres
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
IF and DO UNTIL don't go together ???
How about this - decide which column you want to work with first and use the same bit of code to loop through it ? If DaysAged = 60 Then ncol = 3'C Else ncol = 2'B End If With Columns(ncol) Do Until Cells(i) = "" 'Do until record is empty CurrentVendorNo =...- PhilipAyres
- Post #6
- Forum: VBA Visual Basic for Applications (Microsoft)
