VBA cell value as an address

[Lord of cells]

Hi,
I need little bit help. I have inventory list which contains about 300 parts, there are just 3 columns PN, Name and PCS.
I want to do VBA code where I can add or remove stock. It have to be very simple so when you write right PN number it gives you name, stock and cell address.

How I can use that cell address (F9 in picture) to add value from PCS + Available ?

Thanks!

 

[offthelip]

Welcome to the forum. Why not use the PN number to find the correct row rather than trying to reinterpret the cells address. you can use index, match or a more sophisticated way of doing an index match using the VBa object of a dictionary, which is worth it if you have thousands of rows but for 300, I would think index match will be fast enough.
If you really want to use the text in the cell you can do it using this code

Dim rng As Range
tt = Range("N10")
Set rng = Range(tt)