Delete cell data in another worksheet based on reference from another cell

taquitoxz

New Member
Joined
Jan 6, 2014
Messages
9
Basically I have a cell A1 in worksheet1 with value "=sheet2!B17"

I want to go to cell B17 in sheet2 and delete that value. How can do that considering that I only have knowledge of cell A1 in worksheet1 ? Thanks.
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
you could highlight the formula in the cell, and copy. (F2, Ctrl + home, Ctrl + C)
then press control + G and paste the formula into the refence field. click ok. Or all by keyboard is:

F2, Ctrl + Home, Ctrl + C, Ctrl + G, Ctrl + V, Enter.

That will take you to the link.
 
Upvote 0
First step would be to record the functions you want to do
View/Macros/Record Macro
The do the actions you want to do (Refer to Post #2)
Then review the code you have created (Alt + F11),
If it's the same cells each time, then the recording can be replayed for the same result.
 
Upvote 0
Try something like this if the formula is a simple link formula like =sheet2!B17

Range(Range("A1").Formula).ClearContents
 
Upvote 0

Forum statistics

Threads
1,213,489
Messages
6,113,953
Members
448,535
Latest member
alrossman

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top