Button does not generate proper colors?

cloudforgiven · #3 12-22-2016, 06:24 AM

Awesome it works, I am sorry for giving you more work but I also have a button that generates rows that is having the same issue of generating the rows but not the proper cell colors, can you take a look at it? here is the code:

Code:

Dim varUserInput As Variant
 
 varUserInput = InputBox("Enter The Last Row Number In The Table:", _
  "What Row?")
  
 If varUserInput = "" Then Exit Sub
 
    Dim RowNum
    
    RowNum = varUserInput
    Rows(RowNum & ":" & RowNum).Insert shift:=xlDown
    Rows(RowNum - 1 & ":" & RowNum - 1).Copy Range("A" & RowNum)
    Range(RowNum & ":" & RowNum).ClearContents

there are rows but no color?

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
proper	snoforlife	Excel Programming	0	01-26-2016 02:16 PM
Hyperlinks Not Linking to Proper Sections of Doc	MoiraB	Word	2	08-26-2015 07:13 PM
Proper Text Format	sufian,naeem	Excel	1	05-05-2014 05:59 AM
Unable to change font colors from theme colors	choy	Word	3	08-01-2012 09:12 PM
Proper Excel Table of Contents (ToC)	judicial85	Excel	1	10-23-2011 01:35 PM