View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
esskaykay esskaykay is offline
external usenet poster
 
Posts: 1
Default Relative Macro Assignment

I have a generic MACRO question. I undestand the relative/absolut
principle. However, when using the "Record a new macro" option, an
set the macro to Relative, it does not appear to be repeating the sam
key stokes I typed.

Example-
Say I have a column of text and I want to delete the second characte
of each cell. I clicked Record amacro, set to relative, then keyed:

Edit, Home, Right, Delete, Enter

Then stopped recording. If my original column is:

Dog
Cat
Mouse

I want

Dg
Ct
Muse

But I get
Dg
Dg
Dg

Thanks,
SK

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