Excel active cell macro

Nowise, on Tuesday 23 September 2008 à 13:16:54

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 to copy and paste a spesific range from the same row the active cell is selected to a specific location. The Program would alter what it copies depending on which row the active cell is..

Can someone please help me I've tried but I don't seem to get it to work properly.

Thanx in advance
- Nowise excel programmer

Reply to Nowise 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

natgt123, on Tuesday 23 September 2008 à 18:39:10

hi,

have you tried reading the help files about macros on the forum itself you might get what you are in search of in it

Reply to natgt123

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

Nowise, on Tuesday 23 September 2008 à 19:54:05

Hi,

I've tried something in this style,

Sub ()
Worksheets("Sheet1").Activate
Range("A1:D10").Select
If active.cell.selected Then
Selection.Copy
Sheets("Sheet1").Select
Range("A1:M1").Select
ActiveSheet.Paste
Else
End If
End Sub

I manage to get active cell to do simple tasks, but I can't find or manage to get it to
copy from the same row. E.g. If I clik on cell B5 the program is supposed to copy data
from F5:H5 and paste it into A1:C1 on the same sheet and so on...I've tried using the row command
without success.

I couldn't find what I was looking for on the forum..sorry - I'm open to suggestions

Regards,
Nowiser

Reply to Nowise

Ask your question Reply

Résultats pour Excel active cell macro

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

Excel Named Range to single cell Hello Everybody, I want to name range single cell by the value of the active cell, may i know how to do it??? For example, in cell A1 I've value "XXXX_07", and i want the cell A1 named as XXXX_07 in cell B1 I've value "XXXX_08", and i want... en.kioskea.net/forum/affich-16058-excel-named-range-to-single-cell

DATE FORMATTING IN dd/mm/yyyy Hello, i have got dates typed in the format following 01.08.98 and i want to change it to 01/08/1998 format.i tried applying the format we have in excel format cell date format but nothing is happening.please help me on this. en.kioskea.net/forum/affich-22133-date-formatting-in-dd-mm-yyyy

1 2 3 Next

Résultats pour Excel active cell macro

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

1 2 3 Next

Résultats pour Excel active cell macro

Instal XP (Solved)Bonjour, Bonjour, J'ai un portable HP Compaq 6720 S qui tourne sous Vista; j'ai voulu remplacer Vista par XP: Format du disque Sata puis install XP et au d�but de l'install il me dit qu'il n'y a pas de disque. J'ai... en.kioskea.net/forum/affich-6855262-instal-xp

Excel: Macro HelpHello, 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

Macro help - search for text in ExcelHello, I've been trying to wrap my head around how to do this but haven't had any luck -- I want to search for text in excel in a spreadsheet of 4000 entries...so it'll save a ton of time. Here's the situation I want solved. I have... en.kioskea.net/forum/affich-19906-macro-help-search-for-text-in-excel

1 2 3 Next

Résultats pour Excel active cell macro

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

Worksheet - Cells A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also used). Coordinates... en.kioskea.net/tableur/tabcellule.php3

Spreadsheets - Data Entry A cell of a worksheet can contain a value or be empty. The value of a cell has two essential characteristics: a type, which means the intrinsic type of the data. There are generally three types of values: numeric values, for example 3.1415927, 58%,... en.kioskea.net/tableur/tabsaisie.php3

1 2 3 Next