![]() |
#3
|
|||
|
|||
![]()
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? Last edited by cloudforgiven; 12-22-2016 at 09:59 PM. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
proper | snoforlife | Excel Programming | 0 | 01-26-2016 02:16 PM |
![]() |
MoiraB | Word | 2 | 08-26-2015 07:13 PM |
Proper Text Format | sufian,naeem | Excel | 1 | 05-05-2014 05:59 AM |
![]() |
choy | Word | 3 | 08-01-2012 09:12 PM |
![]() |
judicial85 | Excel | 1 | 10-23-2011 01:35 PM |