VBA Code, Select the last non-blank(visible) cell with a value in Column C

[yeahprettimuch]

Hello All,

I am a novice to VBA but well verse in writing formulas.

I would like a VBA code to go to Sheet "Slide 1 Chart 1", select the LAST CELL in Column C that has a populated(visible) cell value, copy that cell, and then paste(value only) into that same cell.

Each cell in Column C had/has a formula that pulls in "Values" if the formula is true. I run a report each day were the last cell with a value in Column C is dynamic by a formula. The cells above it are static(No formula). On the following day of running that report the last cell with a value needs to become static. Thus "Select", "Copy", "Paste(Values only)".

LastColumn;Row;Cell does not work as it still see's the formula in the visibly blank cell and considers it the lastrow. It should ignore the formulas and only look at if a value(not data) is populated.

Please help me with this!
above.PNG

lastcell.PNG

below.PNG

Thank you,

[mehmetcik]

Please Login or Register  to view this content.

[yeahprettimuch]

Thank you! I'll give this a try