Select a subset of cells within a row

Mario, on Friday September 5, 2008 02:46:28 PM

Hello,

I am trying to select a number of cells within a row - I want to use this in a macro.
Whatever cell is currently active, I want to select cells from column B to Column M in the current row.

Thanks, M

Configuration: Windows XP
Internet Explorer 6.0

Reply to Mario Report this message to moderators Go to last message

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

Ivan-hoe, on Sunday September 7, 2008 06:46:18 AM

With ActiveCell
    Range(Cells(.Row, "B"), Cells(.Row, "M")).Select
End With

Reply to Ivan-hoe

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

Mario, on Monday September 8, 2008 08:41:13 AM

Thanks very much.

You suggestion is "Spot On".

Reply to Mario

Ask your question Reply

Results for

Excel active cell macro Hello, I'm trying to write a macro in excel which would copy and paste a range from WITHIN THE SAME ROW in the same sheet as the active cell is selected. For example let's say i select a cell within range A6:P36 then i would like the macro... en.kioskea.net/forum/affich-25813-excel-active-cell-macro

Datagridview Hello, I have a datagridview with 3 rows and 3 columns ,and i want to select a cell in this datagridview ,and save the previous selection . help me please en.kioskea.net/forum/affich-421-datagridview

Help with row command (Solved) Hello, I'd like excel to move the number one to move in column A to row user the user selects with the mouse (or the active cell is) for instance. If user selects C6 the macro would put the numer one in A6 and when user selects another cell in a... en.kioskea.net/forum/affich-26508-help-with-row-command

1 2 3 Next

Results for

Excel tips : How to insert date In an Excel cellExcel tips : How to insert date In an Excel cell Below are some tips on how to insert date and time in an excel cell for a specific purpose:- To insert current date, press “CTRL”+ “;” in the chosen cell. To insert current... en.kioskea.net/faq/sujet-313-excel-tips-how-to-insert-date-in-an-excel-cell

A connected PC will be infected within the first 5 minutes.A connected PC will be infected within the first 5 minutes. Myth Truth Myth Your PC gets infected during the first 5 minutes of internet connection. Truth In fact all operating system possess flaws and bugs due to programming errors... en.kioskea.net/faq/sujet-455-a-connected-pc-will-be-infected-within-the-first-5-minutes

Secretly enter a password within consoleSecretly enter a password within console Here is a simple method on how to limit the use of a specific command (as to prevent the display screen by disabling the echo command), using stty. Just launch the command (to disable) using stty... en.kioskea.net/faq/sujet-795-secretly-enter-a-password-within-console

1 2 3 Next

Results for

Sums of row cellsHello, I use an excel spreadsheet for bookkeeping purposes for a single person corporation. I want to total amounts across each row. In other words the last cell of row one contains the sum of columns c1 to t1; the last cell of row 2 contains the sum... en.kioskea.net/forum/affich-27843-sums-of-row-cells

Copy data onto sheet only if cell has textHello, I need to copy formulas and data from a selection of cells in a worksheet (Figures) onto a seperate sheet (summary). I would like the information to automatically copy across to the sheet (summary) as i type on the original page (Figures). I... en.kioskea.net/forum/affich-22213-copy-data-onto-sheet-only-if-cell-has-text

Place found value to specific colm headerHello, I have this code which looks like this If MYF(FLD) = "012007" Then Cells(ActiveCell.Row, "J").Value = "Y" If MYF(FLD) = "012007" Then Cells(ActiveCell.Row, "K").Value = "Y" If MYF(FLD) = "022007" Then Cells(ActiveCell.Row, "L").Value = "Y" If... en.kioskea.net/forum/affich-25092-place-found-value-to-specific-colm-header

1 2 3 Next

Results for

Download SelectView FilterInternet is certainly an unfailing source of information, but some sites and some Web pages include too many pubs. These pubs block the bandwidth and decelerate considerably your speed of connection. Select View Filter is a program allowing to filter... en.kioskea.net/telecharger/telecharger-484-selectview-filter

1 2 3 Next

Results for

China's mobile users top 600 million: govtA woman speaks on her mobile phone in Beiijng on April 6, 2008. The number of mobile users in China, the world's biggest cellphone market, now tops 600 million, the government said, as subscribers increasingly abandon fixed lines. The number of... en.kioskea.net/actualites/china-s-mobile-users-top-600-million-govt-10563-actualite.php3

Mitsubishi Electric plans major solar cell investmentThe roof of a house in Dardesheim, eastern Germany, is covered with solar cells. Japan's Mitsubishi Electric Corp. said Wednesday it planned to invest 70 million dollars to boost production of solar cells as global demand rises on high oil costs... en.kioskea.net/actualites/mitsubishi-electric-plans-major-solar-cell-investment-10219-actualite.php3

Japan to get cellphone 'sommeliers': officialJapan is to start licensing cellphone "sommeliers" to guide consumers through complicated functions as mobile telephones become ever more advanced, an official said Monday. The communications ministry said it was planning to support a private-sector... en.kioskea.net/actualites/japan-to-get-cellphone-sommeliers-official-10006-actualite.php3

1 2 3 Next

Results for

Spreadsheets - Cell Selection Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells. An entire line can be chosen by clicking directly on the line header: It is also possible to choose... en.kioskea.net/tableur/tabcellselect-1.php3

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

Cryptography - Substitution cipher Substitution cipher involves replacing one or more entities (generally letters) in a message with one or more other entities. There are several types of substitution cryptosystems: Monoalphabetic substitution involves replacing each letter in the... en.kioskea.net/crypto/simple.php3

1 2 3 Next