Save a Workbook With A file path and name referenced cell

Please Login or Register  to view this content.

Regards, TMS

Some options:

Please Login or Register  to view this content.

The first is a basic range statement. The second is a short cut evaluation ... I rarely use this. The third is a reference to a named range. And the last refers to a variable containing a cell address string.

Not sure where you got your range([...]) from although you do see stuff like that in relation to Tables. For example:

Please Login or Register  to view this content.

... will loop through every cell in the Status column in the tabSummary Table.


Regards, TMS

If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.