Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Jeff Cunningham   on Sep 20 In MS Office Category.

  
Question Answered By: Fergus Jones   on Sep 20

sounds like you may have the right 'relative address' but not the right sheet.
When the 'hit' or 'search result' is found, you need to add the spec to identify
the sheet name or index; in the example looks like you are setting up Sheet
Indexes by the k value. If so, try this:

Sheets(k).Cells(rngA.Row, [e:e].Column).Value = recdate.text

see if that get you what you need.

Share: 

 

This Question has 17 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on Find Value then Replace something else Or get search suggestion and latest updates.


Tagged: