Ok, bear with me, I'm still pretty new at this.
My VBA code uses the value of a cell to change an image. That value is updated by a drop down list. However, when I add rows, that cell reference is no longer valid in the code. Is there a way to make that reference update when rows are added to the worksheet?
You can name the cell (Name Manager on the Formula tab) and then refer to that name in code instead of a cell reference - e.g.:
Please Login or Register to view this content.
Remember what the dormouse said
Feed your head
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks