Am using code found below to autosize 3 columns to fit the values that they return. The results are dependent on inputs from combinations of 3 other cells, and entry into those cells will change the results of the columns. The results work fine, but the now rezised columns D:F remain selected after changing one of the 3 cells. Am looking for a way to accomplish the following:
After changing the value in the entry cells is to just have the active cell remain where it was directed to go, either by using the tab, or enter key, down arrow, etc. So, if I change the value in B1 and use the down arrow for example, B2 would be selected after resizing the 3 columns. Or using the tab key, C1 would be selected after resizing the columns.
I've tried recording code to replicate "enter", but nothing gets captured.
TIA for any modifications to the code.
Pete
Bookmarks