auto fill numbers

rollis13 · #1 05-13-2021, 03:39 AM

Change the line of code to:

Code:

If Cells(i, x) <> "" Then Cells(i, col * 2 - x + 1) = Cells(i, x) + 1

Urraco · #2 05-13-2021, 04:37 AM

Solved!
Good luck!

Quote:

Originally Posted by rollis13

Change the line of code to:

Code:

If Cells(i, x) <> "" Then Cells(i, col * 2 - x + 1) = Cells(i, x) + 1

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