Hi,
I have seen multiple posts on this subject but I am not able to adapt the code to my specific need, please help.
I need to do the famous F2 then ENTER combination for the following :
-VBA to be available in sheet "Report XML" only.
-Starting with cell "T2", I need to do the F2/ENTER combination, need to go downward until I hit 50 consecutive empty cells, in case there are small gaps (always less20-25 cells) in the column.
-Since the column potentially has lots of active cells in a column I would like to increase speed by disabling visual feedback.
-Focus to return to "T2" when finish.
-Sheet "Report XML" is password protected but column "T" will not be locked.
Please add explanation so I can adapt to other sheets with same type of issue.
Thanks for the help.
I have seen multiple posts on this subject but I am not able to adapt the code to my specific need, please help.
I need to do the famous F2 then ENTER combination for the following :
-VBA to be available in sheet "Report XML" only.
-Starting with cell "T2", I need to do the F2/ENTER combination, need to go downward until I hit 50 consecutive empty cells, in case there are small gaps (always less20-25 cells) in the column.
-Since the column potentially has lots of active cells in a column I would like to increase speed by disabling visual feedback.
-Focus to return to "T2" when finish.
-Sheet "Report XML" is password protected but column "T" will not be locked.
Please add explanation so I can adapt to other sheets with same type of issue.
Thanks for the help.