Sunline
Well-known Member
- Joined
- Oct 6, 2007
- Messages
- 701
- Office Version
- 2016
- Platform
- Windows
Hello all ,
I'm trying to use auto fill in its normal way , where you ,
Highlight col
Ctrl +G
Special
Blanks
OK
Then it starts going thru a random selection looking at cells . i can see this happening in the pane directly under the word clipboard . Top left in excel .
It tells me no cells found .
I had this working but am getting this all the time .
I also had a macro written which worked but now just auto fills only row 2 cell and fills to bottom which should be finding all other cells to auto fill . Confused . what might i be doing wrong .
Thanks .
I'm trying to use auto fill in its normal way , where you ,
Highlight col
Ctrl +G
Special
Blanks
OK
Then it starts going thru a random selection looking at cells . i can see this happening in the pane directly under the word clipboard . Top left in excel .
It tells me no cells found .
I had this working but am getting this all the time .
I also had a macro written which worked but now just auto fills only row 2 cell and fills to bottom which should be finding all other cells to auto fill . Confused . what might i be doing wrong .
Thanks .