len replace part 2

T

tom_mcd

**<__>**........<__>........SS<__>..........<__>DDDDDDDDDD<__>
**<__>**........<__>..........<__>..SSDDDDDD<__>DDDD..DDDD<__>
**<__>**........<__>........SS<__>....DDDDDD<__>DDDDDDDDDD<__>
**<__>**........<__>SSDDDDDDDD<__>DDDDDDDD..<__>..........<__>
**<__>**......SS<__>DDDDDDDDDD<__>DDDDDDDDDD<__>..........<__>
**<__>**....SSDD<__>DDDDDDDDDD<__>DDDDDDDD..<__>DDDDDDDDDD<__>

Hi all, this brilliant code below worked and because it worked so well, my
boss has decided he wants the same for absences for which there are 2 letters
D and S, as you can see above. . I can't run them one letter at a time
because that'll overwrite the 1st letter. Can anyone change this code show D
and S on the one spreadsheet. I've tried and made a mess of it.

PS Rick, you were right about the 1/2 days . Thanks again


Sub GetHolidayDates()
 
Top