Excel Help - Equivalent of "Range($G$14:$AD$121).Select" in R1C1 notation

S

statdoug

#1
I don't really know where to post this, but I am looking for the equivalent of "Range($G$14:$AD$121).Select" in R1C1 notation. The specific addresses are not important, but it is for a macro where both row and column must be fed in variable format from the spread sheet. (Thank you Marc for moving this to the appropriate forum).
 
Last edited by a moderator:
Elsmar Forum Sponsor
S

statdoug

#4
I tried several permutations of Range and Cell statements but I don't remember if I tried that specifically. I may have tried it with a colon between the two cell statements. I will try this version 1st thing tomorrow and let you know if it does it. In advance though, thanks for taking the time to lend a hand.
 
A

allan-M

#5
Sugggest you toggle the options settings for using R1C1 on, enter a dummy formula, toggle and enter the formula again (if you know what I mean)
When entering the formula you can use F4 to toggle a reference from relative to absolute
Here's what I got:
relative reference (G14:AD121) is the same as R[13]C[6]:R[120]C[29] - formula is in R1C1

absolute reference $G$14:$AD$121 is the same as R14C7:R121C30

Search excel help for "overview of formulas"
 
S

statdoug

#6
Thanks for your reply. As mentioned above, the specific addresses were not critical. what I was looking for Reynald hit right on the money. "Range(Cells(14, 7), Cells(121, 30))" worked like a charm. it was just a minor syntax issue. I was using a colon instead of a comma between the two cell statements, and of course, i couldn't find an example anywhere.
 
Thread starter Similar threads Forum Replies Date
S Help me build an Excel Spreadsheet for tracking training Training - Internal, External, Online and Distance Learning 14
B Zeiss CMM Calypso output to Excel or CSV file Help Inspection, Prints (Drawings), Testing, Sampling and Related Topics 17
J Excel Help - SUMIF without Duplicates Excel .xls Spreadsheet Templates and Tools 3
Ron Rompen Unusual problem with Excel - Need some help Excel .xls Spreadsheet Templates and Tools 7
R Excel 2003 and Capability Studies for Dummies - Help needed! Excel .xls Spreadsheet Templates and Tools 4
C Corrupt Excel File - Help!!!!!!! Excel .xls Spreadsheet Templates and Tools 9
A MS Excel Font Help from ASQ, AIAG and/or Others Excel .xls Spreadsheet Templates and Tools 6
AnaMariaVR2 Excel - Sorting by Product or Raw Materials [need Help] Excel .xls Spreadsheet Templates and Tools 4
S Distribution Data Graphing in Excel help Excel .xls Spreadsheet Templates and Tools 4
S Excel Spreadsheet Conditional Formatting help needed Excel .xls Spreadsheet Templates and Tools 12
T Excel Time Calculations and Formulas help needed Excel .xls Spreadsheet Templates and Tools 15
Q Excel worksheet - Help required (viewing specific number of rows/columns) Excel .xls Spreadsheet Templates and Tools 4
S How to make graphs with the help of Excel--Like Gaussian distribution, control chart Capability, Accuracy and Stability - Processes, Machines, etc. 1
Y ISO: Help With Records Numbering System & Log in Excel or Access Document Control Systems, Procedures, Forms and Templates 12
smryan Excel Cell or Text Formatting help Excel .xls Spreadsheet Templates and Tools 27
R Need Help with MS-Excel for Mac Excel .xls Spreadsheet Templates and Tools 5
D Need some help with a formula in Excel Please! Excel .xls Spreadsheet Templates and Tools 11
Ajit Basrur Samples Log sheet - need help (Excel Functions) Excel .xls Spreadsheet Templates and Tools 1
D How do I Auto fill colour on excel if certain risk criteria is met on PFMEA? Help! Excel .xls Spreadsheet Templates and Tools 13
A Need help make a bin in normdist - Normal Distribution - Excel Excel .xls Spreadsheet Templates and Tools 4
M Filtering Help with Excel Excel .xls Spreadsheet Templates and Tools 4
C The IF function in Excel - Need help Excel .xls Spreadsheet Templates and Tools 14
S Need help to test my excel worksheet based on ISO 3951 Excel .xls Spreadsheet Templates and Tools 1
Manix Excel Formula for Ebay shop fees - Help needed Excel .xls Spreadsheet Templates and Tools 8
W Excel Function SUMPRODUCT - Need help! Excel .xls Spreadsheet Templates and Tools 11
M Need excel formating help - Have excel automatically populate a column Excel .xls Spreadsheet Templates and Tools 19
J Seeking Excel Spreadsheet to help with cycle test for Weibull failure rates Excel .xls Spreadsheet Templates and Tools 2
M Can someone help me create a POISSON ACUMULATIVE PROBABILITY table in Excel? Excel .xls Spreadsheet Templates and Tools 1
C Template for Excel Validation Reliability Analysis - Predictions, Testing and Standards 5
R Gage R&R Excel templates Gage R&R (GR&R) and MSA (Measurement Systems Analysis) 3
S Issuing of CoC to Customer in a Word or Excel format ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
Ajit Basrur Track audit findings on Excel tracker Excel .xls Spreadsheet Templates and Tools 9
J Does anyone have an excel IATF 16949 Internal Audit checklist I could use? IATF 16949 - Automotive Quality Systems Standard 7
S Anyone Familiar with "SPC for Excel" add-in? Lean in Manufacturing and Service Industries 4
P Commercial excel templates that calculate overhead, hourly rates, fee proposal Excel .xls Spreadsheet Templates and Tools 0
I Cannot Export multiple sections from Excel to PDF without losing pagination Excel .xls Spreadsheet Templates and Tools 23
M Matching two matrices in Excel Excel .xls Spreadsheet Templates and Tools 5
J Level 3 KPI Excel Template Manufacturing and Related Processes 1
bobdoering Informational New AIAG PFMEA Process - Excel Template Attached FMEA and Control Plans 23
GreatNate Excel PPAP Tracking templates or tool wanted APQP and PPAP 1
E Part 11 Compliance, Excel living documents (i.e. document master list, equipment list, approved supplier list) Pharmaceuticals (21 CFR Part 210, 21 CFR Part 211 and related Regulations) 3
J ISO 9001:2015 Excel Gap Analysis wanted ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 7
B AS9110 Audit Check Sheet wanted Excel or Word Document AS9100, IAQG, NADCAP and Aerospace related Standards and Requirements 2
G Excel report with pictures Excel .xls Spreadsheet Templates and Tools 5
A Query regarding MS Excel usage Excel .xls Spreadsheet Templates and Tools 2
A Excel OOT (Out of Tolerance) Formula Excel .xls Spreadsheet Templates and Tools 3
D Asterix when pasting a column of values from Excel into Minitab (V17) Using Minitab Software 5
Y Excel Automation - Printing Word Documents from within Excel Excel .xls Spreadsheet Templates and Tools 0
P Template or example Excel list of ISO certificates issued to clients ISO 9000, ISO 9001, and ISO 9004 Quality Management Systems Standards 5
M Medical Device Process validation, Validation of excel spreadsheets used for process Other Medical Device and Orthopedic Related Topics 4

Similar threads

Top Bottom