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!
-
Relative Reference Print Area Glitch
Note: I use Excel XP, with Windows 2000, and Excel XP VBA - If I print a range of cells manually, or with VBA code using absoulte referencing, I can print the entire range without issue, even if there is data (letters, symbols, numbers or even a single space) in the TOP MOST LEFT HAND CELL of...- dls999
- Thread
- Replies: 0
- Forum: Visual Basic (Classic)
-
how do I pick out and change a cell reference?
How can can pick out a cell reference in a formula based on certain criteria? for example: =if(AB12 / 3 = c21, g21, z15) any column reference after the letter "K" I would like to change to the same cell on a different sheet, but, I would like to do a bunch at a time. (any ref...- dls999
- Thread
- Replies: 1
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Logic test in "If then else" statement in error
Hi, I have written an "if then else" statement in VBA for Excel XP. FR3, FR2 and FormL are String Variables If FR3 = "$" Then If FR2 > "M" Then FormL = "N" Else FormL = "L" End If GoTo Skip_2nd_Test End...- dls999
- Thread
- Replies: 2
- Forum: VBA Visual Basic for Applications (Microsoft)
