Learning Excel Fast And Easy

ChemistB · #1 01-31-2008, 04:45 PM

This is a question about one of the tips in Learning Excel Fast and Easy but there's not folder for that so I thought this was the next best thing. On page 115 (or 136 in PDF) J Rubin discusses using the GET.CELL command from the old XLM in combination with Conditional formatting to highlight formulas. He defines the name with

Code:

=GET.CELL(48,INDIRECT(“rc”,FALSE))

VBA Noob · #2 01-31-2008, 04:56 PM

I believe it refers to R1C1 cell references

See if links explain more for you

http://www.cpearson.com/excel/Call.htm

http://www.sulprobil.com/html/get_cell.html

http://www.j-walk.com/ss/excel/usertips/tip045.htm

VBA Noob

ChemistB · #3 02-01-2008, 10:45 AM

Thanks VBA! This will help me a lot with my spreadsheet validations.

ChemistB

Welcome to the Excel Forum

Forum Statistics