Selecting a range

From: Dean (Dean_at_discussions.microsoft.com)
Date: 12/27/04 

Date: Mon, 27 Dec 2004 07:13:05 -0800

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: Message box to pop up if a particular value is entered
    ... I have one more novice question though, ... Private Sub Worksheet_Change ... The problem is that when I added a second worksheet change macro, ... > Assumes A1:B3 does not have merged cells. ...
    (microsoft.public.excel.programming)
  • 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)