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!

Register Log in
  • Congratulations gkittelson 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: *

  1. str8up4u

    Relative Reference Toolbar will not pop-up

    I'm using Excel XP. For some reason, when I start a new macro, the Stop Macro and Relative Reference Smart Icons that usually pop-up no longer appear. I have closed the application and restarted with no change and rebooted. Does anyone have any ideas how to get this option back?
  2. str8up4u

    Formula does not recognize concatenated value

    Hah! I solved my own problem. I added the Value function to the cell address. ActiveCell.FormulaR1C1 = &quot;=IF(Value(RC[-1])>88,&quot;&quot;X&quot;&quot;,IF(Value(RC[-1])<60,&quot;&quot;Y&quot;&quot;,RC[-1]))&quot; Bingo! Works out perfectly.
  3. str8up4u

    Formula does not recognize concatenated value

    I used a formula to concatenate 2 values, copied the results and pasted the values. Using another formula on the results , it does not recognize the pasted values, returning inaccurate results. Sub Macro1() ' Range(&quot;H51&quot;).Select ActiveCell.FormulaR1C1 = _...

Part and Inventory Search

Back
Top