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.
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

dermie_72

Well-known Member
Joined
Sep 4, 2012
Messages
1,540
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.
 

taquitoxz

New Member
Joined
Jan 6, 2014
Messages
9
Hi, I am creating a macro hence referring to in VBA language. Does anyone knows how ?
 

dermie_72

Well-known Member
Joined
Sep 4, 2012
Messages
1,540
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.
 

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,400
Try something like this if the formula is a simple link formula like =sheet2!B17

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

Watch MrExcel Video

Forum statistics

Threads
1,127,567
Messages
5,625,568
Members
416,118
Latest member
kamil_tuncer

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
Top