View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stutsman Stutsman is offline
external usenet poster
 
Posts: 1
Default relative versus specific cells in macros/vba

A macro I'm trying to write has to include a "copy-find-paste-modify" string,
but I don't know how to generalize the active cell choice to be dependant
upon the results of the "find" rather than a specific cell typed in vba.

So, how do I write "find cell, move four cells to the right of found cell,
modify that cell" rather than, "move to r1c1, modify?" I'm looking
essentially for a variable plug within r1c1 rather than a specific grid
placement.