On Win7 Office 2010 pro machines I have code that does an autofill operation. I discovered on 2 of my clients office machines autofill doesn't work - at all. Whether you manually grab one cell, or 3 in a series cells, it will always return the first cell value. For example if you had "A" and "B" in a column, selected, dragged down you would get "A", not "C".
On my home machine it works fine, manually and with code. So has anyone seen the autofill not work?
Workbook Auto calculation is turned on. No filters in cells.
One clue iswhen you drag down and options box appears, according to other posts it should show a list of fill options where this machine only shows a few and "Fill Series" is not one of them.
Help.
On my home machine it works fine, manually and with code. So has anyone seen the autofill not work?
Workbook Auto calculation is turned on. No filters in cells.
One clue iswhen you drag down and options box appears, according to other posts it should show a list of fill options where this machine only shows a few and "Fill Series" is not one of them.
Help.