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 Mike Lewis 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: amm9290
- Order by date
-
Excel VBA question
sub RemoveIt MCol = Range("M:M").Column For Each c In Range("H1", Cells(Range("H:H").Rows.Count, Range("H:H").Column).End(xlUp).Address) If c.Value = "00/00/00" Then Cells(c.Row, MCol).Value = "" End If Next c end Hope it helps.- amm9290
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
excel macro
This will work. Add this code to a module. Select the range of cells you want the char removed from. Then run this routine. Sub Remove() char = InputBox("Enter char to replace") For Each c In Selection c.Replace what:=char, replacement:="" Next c End Sub AMM9290- amm9290
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
How can I tell if a worksheet already exists?
Without looping you can do this. function SheetExists(theName as string) On Error GoTo DoesNotExist Sheets(theName).Activate sheetexists = True On Error GoTo 0 Exit Function DoesNotExist: sheetexists = False On Error GoTo 0 Exit Function End Function- amm9290
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
calculating difference in dates in excel
If you had a hidden (or out of sight) cell on your worksheet you could do something like this one-liner: =IF((EDate(SomeDateDataPoint,3)< TODAY()),CallWarning()) where SomeDateDataPoint is your "old" date and 3 is number of months from the "old" date. This...- amm9290
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
