code involving two workbooks, runs correctly from one workbook but not the other

[mmmooottt]

Hello All,

My first time posting here and very much a beginner in the VBA world.

I have some code that gets some cell references from one workbook in order to reference a cell in another workbook.

For some reason running it from the first workbook it wont let me select the cell in the second one, but if i reverse things and run the code from the second workbook, it works fine.

I dont know what I have wrong! any advice would be appreciated. I need it to run from the first one for various other reasons further down the line.

Please Login or Register  to view this content.

[Sunny18pc]

Hi,

If you want to reverse the process just replace the file name & sheet name of first with second one.
200117_Pricing Sheet.xlsm with 200117_Xylo Sales Cash Flow.xlsm and vice versa

Attach the sample file to assist better, refer the yellow banner above
HOW TO ATTACH YOUR SAMPLE WORKBOOK:

[mmmooottt]

Hi Sunny,

Thanks for the hint, Ill give it a try and attach the workbook if I cant get anywhere with it !

Best

[Richard Buttrey]

Hi and welcome to the forum

Do you literally mean that the macro refuses to select a cell and an error message pops up ("it won't let me select the cell"), or it selects a cell but not the one you expect?

As has been suggested plese upload the two workbooks.