Rows and Columns RC[7]

E-coli, on Thursday August 28, 2008 08:02:09 PM

Hello,

I am trying to do some extensive formula writing that involves complex sheet referencing. In my attempts, I do not understand the numbers that come after the R and C in the following. They do not seem to be linear like row and column headings. Could someone explain to me how these numbers work?

ActiveCell.FormulaR1C1 = "=SAF0006!R[-1]C[3]"
Range("C3").Select
ActiveCell.FormulaR1C1 = "=SAF0006!R[-2]C[7]"

Configuration: Windows Vista
Internet Explorer 7.0

Reply to E-coli Report this message to moderators Go to last message

This message seems useful, vote!
Report this message to moderators

Ivan-hoe, on Tuesday September 2, 2008 01:39:51 PM

Hello E-Coli !
the square brackets are used for relative adressing :
if the active cell is C3 (third row / third column), R[-2]C[7] corresponds to J1 (2 rows backwards and 7 columns forward)
For absolute adressing, do not use the square brackets :
R2C7 corresponds to $G$2 (second row / seventh column)
Ivan

Reply to Ivan-hoe

This message seems useful, vote!
Report this message to moderators

E-Coli, on Tuesday September 2, 2008 07:28:32 PM

Ivan-Hoe,

Thank you very much. I can't believe something so simple was causing me such problems.

I have another one for you:

How can I automatically create and name worksheets in a workbook based on a list that exists in another sheet "Summary" in the workbook? The list begins at cell A10. Mind you, this list will vary from workbook to workbook. Do you have some code already compiled to perform this?

E-Coli

Reply to E-Coli

1This message seems useful, vote!
Ce message ne vous semble pas utile, votez !
Report this message to moderators

Ivan-hoe, on Wednesday September 3, 2008 09:11:47 AM

I do not have any code already compiled for what you want, but let me give you some tips

Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet
Sheets(Sheets.Count).Name = "MyName" ' rename the new worksheet

to repeat this as many times as you have names in your list, use a loop (e.g. For Each ... Next)

For Each MyCell In MyRange 'MyRange is the range containing your list
' instructions
Next MyCell

Ivan

Reply to Ivan-hoe

Ask your question Reply

Results for

Pretty Basic Excel Macro Help Hello, I am writing a macro (which will be used to create a VB6 program) in Excel 2003. The spreadsheet Update_Log is a database with 9 user input columns and 7 columns which are calculated by formulas based on user input. I need to create a macro... en.kioskea.net/forum/affich-15106-pretty-basic-excel-macro-help

Excel Macro Help Hello, I am writing a macro in Excel 2003. The spreadsheet Update_Log is a database with 9 user input columns and 7 columns which are calculated by formulas based on user input. I need to create a macro that finds the last record in column A, moves... en.kioskea.net/forum/affich-15107-excel-macro-help

Excel: Macro Help Hello, I ned some help setting up a macro for Excel. I have a lost of IDs/SKUs on Sheet 1, and a partial list on Sheet2. What I would like to do is cross-check the two sheets and delete all the rows on Sheet1 that's already listed on sheet2. The... en.kioskea.net/forum/affich-5884-excel-macro-help

1 2 3 Next

Results for

RCP Server not availableRCP Server not available RCP stands for Remote Procedure Call and if the computer displays “Operation could not be completed. The RPC server is unavailable” while trying to access the printers installed on the computer or trying to... en.kioskea.net/faq/sujet-356-rcp-server-not-available

Low ID on EmuleLow ID on Emule How to prevent getting LowID? For those using DI-5xx, DI-6xx, DI-704P (revC), DI-704UP, DI-754, DI-764, DI-774, DI-784, DI-804HV, DI-808HV, and DI-824VUP: For those using DI-704P (rev.B) and DI-707P: It might happen... en.kioskea.net/faq/sujet-227-low-id-on-emule

Restoring your Nokia phoneRestoring your Nokia phone Normal Reset Deep Reset How to proceed There are two methods allowing you to reset your phone to a more unwavering state. Normal Reset Using the *#7780# sequence. It will restore ini files from ROM... en.kioskea.net/faq/sujet-421-restoring-your-nokia-phone

1 2 3 Next

Results for

Conditionally changing row background colorHi I want to change the background color of the rows in my Excel worksheet based on the value of a certain column named 'Status'. Status can have around 7 values Conditional Formatting might not be the right choice. Following are the values... en.kioskea.net/forum/affich-27450-conditionally-changing-row-background-color

Using awk to extract Excel columnsHello, Hi All, I have Excel files (with TAB delimiter) that have different setting of columns. For Example: 1st Excel file has 18 fields: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 2nd and 3rd are the same which have 14 fields: 1 2 3 4 5 6 7 8 9 10... en.kioskea.net/forum/affich-4673-using-awk-to-extract-excel-columns

Group/Move Rows to New Worksheet VBAHello, I'm trying to find some VBA to do the following steps in excel: 1. Look down column A for similar values (will be in alpha order). 3. Group rows that have similar values in column A 4. Search for worksheet named with value in column A. 4a.... en.kioskea.net/forum/affich-30660-group-move-rows-to-new-worksheet-vba

1 2 3 Next

Results for

Download 7-Zip7Z also known as 7Zip archive utility is available as open source and is free to use. 7Z is fast, efficient and free. Features: High compression ratio in new 7z format with LZMA compression 7-Zip is free software distributed under the... en.kioskea.net/telecharger/telecharger-605-7-zip

Download Driver Driver Nvidia GeForce 7To drive NVIDIA GEFORCE 7 173.14.09 LINUX IA64 X64 is a driver for cards GeForce. It is compatible with cartes Geforce:7950 GX2, 7950 GT, 7900 GTX, 7900 GT / GTO, 7900 GS, 7800 SLI, 7800 GTX, 7800 GT, 7800 GS, 7650 GS, 7600 GT, 7600 GS, 7600 WIDTH,... en.kioskea.net/telecharger/telecharger-847-driver-driver-nvidia-geforce-7

Download Driver Ricoh Aficio GX 7000 RPCS Raster PrinterThe printer Ricoh Aficio GX 7000 is an ink jet printer of ink. Its maximum resolution is of 3600 dpi. It is entirely compatible with the systems PC, Unix and Mac. Its speed d' impression in black and white and color is of 29 ppm. This model is... en.kioskea.net/telecharger/telecharger-964-driver-ricoh-aficio-gx-7000-rpcs-raster-printer

1 2 3 Next

Results for

Spanish police detain 76 in major Internet fraud probeA man uses a mouse to surf the Internet. Police in Spain have detained 76 people acrosss the country as part of what they have described as their biggest-ever probe into Internet fraud. Police in Spain have detained 76 people acrosss the country as... en.kioskea.net/actualites/spanish-police-detain-76-in-major-internet-fraud-probe-10077-actualite.php3

1 2 3 Next

Results for

HTML - Tables Often, it is helpful to present information in a more structured manner than a list. Tables can display this information in rows and columns. The tables are defined as series of rows. A table must follow the rules below: The table is enclosed within... en.kioskea.net/html/htmltable.php3

Cables and connectors - RCA plug The RCA connector (Radio Corporation of America, sometimes called CINCH) is a connector used for transporting audio or video signals. The RCA plug is used to send video and audio signals (in mono or stereo) through a two-wire cable, with either an... en.kioskea.net/elec/connecteur-prise-rca-cinch.php3

Multichannel Audio The term "multichannel audio" refers to the use of multiple audio tracks to reconstruct sound on a multi-speaker sound system. Two digits separated by a decimal point (2.1, 5.1, 6.1, 7.1, etc.) are used to classify the various kinds of speaker set... en.kioskea.net/audio/son-multicanal-5-1-7-1.php3

1 2 3 Next