Thread: How to record macro with relative addressing in Excel 2000
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How to record macro with relative addressing in Excel 2000
On the Recording Toolbar there should be a Relative Reference toggle button.


Gord Dibben MS Excel MVP

On Wed, 12 Aug 2009 14:49:01 -0700, Rond
wrote:

Attempt to record a macro with relative addressing. I have R1C1 option
checked in Toolsoptionsgeneral. After recording a simple macro,
addressing is always absolute. I do not know how to program in visual basic.

Reply With QuoteReply With Quote