Excel macro recording problem

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

From: dg33 (dg33.1b6xid_at_excelforum-nospam.com)
Date: 08/18/04 

Date: Wed, 18 Aug 2004 10:31:27 -0500

I want to record a macro which includes the action of copying the
contents of cell E2. When I record, however, it writes in the VB code
the particular data in E2 on that occasion. I want it to pick up
whatever the data is in E2 and this is not the same every time. Is
there a way to copy "Contents of E2" rather than "Toronto" or whatever
happened to have been in E2 at the time of recording the macro? 

---
Message posted from http://www.ExcelForum.com/

Relevant Pages

  • Re: X Cell Problem
    ... I know I am only copying over seven columns because the source file has ... macro; but you need to understand that macro can do far, ... With the cell you want to ...
    (microsoft.public.excel.programming)
  • Re: X Cell Problem
    ... This macro will ask you how many rows you will want the modified formula copied down for, check to make sure the value you entered can be interpreted as a number, make sure the number entered won't take the copy process past the bottom of the worksheet, modify the formula in the same way my first macro did, then copy that modified formula over 6 more columns and down the number of rows you entered... ... are you copying down to the last ... > particularly since I don't know how many rows each tab has. ... With the cell you want to ...
    (microsoft.public.excel.programming)
  • Re: X Cell Problem
    ... Michael Conroy ... macro did, then copy that modified formula over 6 more columns and down the ... are you copying down to the last ... With the cell you want to ...
    (microsoft.public.excel.programming)
  • Re: VBA: For Count, when count changes from cell to cell
    ... reporting Macro being unavailable. ... Dim LastRowOfData As Long ... Dim LC As Integer ' Loop Counter ... means that you can refer to it in a cell just like a built-in Excel function. ...
    (microsoft.public.excel.misc)
  • Re: How to capture Max cell value (High Water Mark)
    ... That way you wouldn't have to save it in a cell thus ... Sub Test_Enable_Events ... I'm only using it on the same worksheet where the macro was created. ...
    (microsoft.public.excel)