Creating Macro to copy information from cell into another cell using Add Comments

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

Hi,

I want to create a macro that will pick up a range of cells aa19:aa95
In these cells there is a formula
=IF($E19="YES",VLOOKUP($C19,'Brand Detail'!$A$1:$P$5000,AA$6,FALSE),"")
for example

I want to add comments transfering the information (TEXT) to column
(G)

How should the macro coding look like to do this?

Many thkx for your answer
Steven

.

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)