Re: Selecting a range

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 12/27/04 

Date: Mon, 27 Dec 2004 16:30:44 +0100

Hi
maybe
activecell.resize(1,11).copy 

-- 
Regards
Frank Kabel
Frankfurt, Germany
Dean wrote:
> I am attempting to copy a range of cells in a macro.  Each time the
> macro is run the columns remain the same but the rows are different
> each time.  I am able to move the active cell to column A of the
> wanted row but want to select cells from A through K in that row only
> to copy.   Am a complete novice to Office programming.  Help

Relevant Pages

  • RE: Comparing Rows
    ... retested the macro on a test worksheet I created. ... REMOVE DUPLICATES ALL COLUMNS ... The macro went through fairly quickly and everything was A-OK. ... Excel 2003) and therefore it wouldn't matter as some cells may be blank. ...
    (microsoft.public.excel.programming)
  • Re: Cell Protection Query
    ... If you don't see the msgbox, then the macro that you added the code to isn't ... These are the cells I'm having the problem with. ... I now fully realise that Merged Cells Are the Root of All Evil! ... protection, ..., I'd try it first. ...
    (microsoft.public.excel.misc)
  • Re: Cell Protection Query
    ... I still don't see how this macro can work on your protected sheet. ... cells, unlock all the cells in the mergearea, merge those cells, and reportect ... BUT the protection issue has disappeared. ...
    (microsoft.public.excel.misc)
  • Re: Rows and Coloumns
    ... As far as I know, if there are any merged cells in a table, macros cannot ... following macro goes through all the tables in a document, ... Merged cells are no problem for this macro. ... Dim findArray As Variant ...
    (microsoft.public.word.vba.general)
  • Re: Cell Protection Query
    ... The macro did solve the text-wrapping / row height issue, ... These are the cells I'm having the problem with. ... I now fully realise that Merged Cells Are the Root of All Evil! ... Delete key then I get the sheet protection message. ...
    (microsoft.public.excel.misc)