Referencing cells in VBA

**Vicki-MS** · 03-23-2024, 07:56 PM

Hi all

I'm having a brain fog moment -

I have a workbook that contains many links to a customer portal

I want to be able to update the portal ID across all links within the workbook based on the value added to a specific cell

The master copy of the workbook has my portal ID (being the referenced ""143655455"") - my aim is to be able to just make a copy of the workbook for a new customer and replace my ID within all links with their ID easily

At the moment I have this but I know its not correct - can someone help - its the "Range(F5)" section - I need to reference the value that is in Cell F5

Please Login or Register  to view this content.

Also, happy to hear if someone has a better work around for this process

Thanks
Vicki

**wk9128** · 03-23-2024, 08:09 PM

pls try this code

Please Login or Register  to view this content.

**Vicki-MS** · 03-24-2024, 08:03 AM

Thanks

This doesn't seem to replace the ID with the value in F5 - it just removes my ID from all the links

** Apologies if you are getting multiple replies - they are not showing my end so not sure if they are posting - I'm new here - please don't hate me!!

**wk9128** · 03-24-2024, 08:46 AM

Originally Posted by Vicki-MS

Thanks

This doesn't seem to replace the ID with the value in F5 - it just removes my ID from all the links

** Apologies if you are getting multiple replies - they are not showing my end so not sure if they are posting - I'm new here - please don't hate me!!

Please Login or Register  to view this content.

**Vicki-MS** · 03-24-2024, 12:50 PM

Perfect!!

Thank you!!!

**wk9128** · 03-24-2024, 09:48 PM

@Vicki-MS You're Welcome. Glad to help . Thank You for the feedback.

If you finally get a solution please mark your thread as SOLVED:
- Click Thread Tools above your first post,you will see the word PREFIX on the upper left, press the button to select [SOLVED] select "Mark your thread as Solved".
- you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help
was given. By doing so you can add to the reputation(s) of those who helped.

Referencing cells in VBA

LinkBack

Thread Tools

Rate This Thread

Display

Referencing cells in VBA

Re: Referencing cells in VBA

Re: Referencing cells in VBA

Re: Referencing cells in VBA

Re: Referencing cells in VBA

Re: Referencing cells in VBA

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA Cells, how to put dynamic formula referencing to specific cells (Row,Column)

Google Sheets - How to create graph from cells referencing other cells sorted/filtered dif

Google Sheets - How to create graph from cells referencing other cells sorted/filtered dif

How do I use countifs function when my range of cells is referencing other cells.

Cells referencing one another

Table Cells Referencing Specific Cells

[SOLVED] Referencing Cells

Bookmarks

Bookmarks

Posting Permissions