auto fill numbers

		Microsoft Office Forums > Microsoft Excel > Excel Programming
auto fill numbers

05-13-2021, 03:14 AM

Urraco

Windows 8

Office 2016

Advanced Beginner

Join Date: Apr 2018

Posts: 30

one more thing, when empty cells are found, the script adds 1, can this cells remains empty?

Quote:

Originally Posted by rollis13

Glad having been able to help

.

Since you have only titles in row 1 then maybe change these lines of code to:

Code:

col = Cells(i, Cells.Columns.Count).End(xlToLeft).Column
'col = Cells(i, 1).End(xlToRight).Column

Attached Images

[1]05-13-2021.jpg (60.6 KB, 33 views)

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
auto fill up	mare1984	Word	1	06-27-2019 08:09 PM
Auto Fill Forms	pgilbert0824	Excel	2	10-30-2016 01:02 AM
Excel Auto-fill Issues	officeboy09	Excel	8	01-14-2014 05:52 PM
auto fill a word doc from another program	hcubed	Office	0	06-19-2013 09:42 PM
Auto Color Fill Question	Kinar	Excel	3	05-14-2013 07:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:34 PM.