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 derfloh 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: KathyD
- Order by date
-
Conditional Formatting-EXCEL
I don't know if this is much help but could I suggest that you change your greater than and less than conditions to be 'betweens'? For instance: condition 1) if cell < 25 then yellow condition 2) if cell > 700 then red condition 3) if cell between 25 and 700 then blue could be changed to...- KathyD
- Post #2
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Range Name Question
The formula is referring to the sheet and not the named range. I've seen people use VBA to assign a name to the range and then adjust their formula to refer to the range. i.e. GeneralLedger!$B$9:$B$4800 named as 'ABC', GeneralLedger!$D$9:$D$4800 named as 'DEF', GeneralLedger!$Q$9:$Q$4800 as...- KathyD
- Post #6
- Forum: Microsoft: Office
-
Range Name Question
If your formulas are referring to the named range then they should be updating as well. I've seen instances where a range is named identically to the sheet it resides in (i.e. sheet name "HourlyData" and the range of data on the sheet is named "HourlyData"). It might help...- KathyD
- Post #3
- Forum: Microsoft: Office
-
Vlookup
rpg121 - Try this. First record a macro (Macro1). Enter the VLOOKUP formula you are wanting to code into a cell in the spreadsheet and then stop recording. Edit Macro1 and voila! there's your VBA code. Hope this helps!- KathyD
- Post #4
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Message Box
Muzzy - Make sure to assign a variable to the answer of the Msgbox. ans = MsgBox "Are You Sure You Want To Submit The Quarterly Figures?", vbOKCancel, "Are You Sure?" If ans = vbCancel Then Exit Sub Else DoCmd.Hourglass True stDocName =...- KathyD
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
-
Check if file is open before sending the data
Hi there. I recently had this problem myself. I found this to work: Workbooks.Open Filename:= abc.xls If ActiveWorkbook.ReadOnly = True Hope this helps. Cheers KathyD- KathyD
- Post #2
- Forum: Microsoft: Access Modules (VBA Coding)
