excelhelpseeker
New member
- Joined
- Jan 7, 2015
- Messages
- 29
- Reaction score
- 0
- Points
- 0
Hi Champs,
i Have dynamic range in A column which has serial number with blank cells underneath it.
For example, the serial in A3 range has 4 blank cells underneath it A3:A7, but coloured only from A3:A5...... i have many example like this .... i need a macro to copy the format only (colour) until the next serial number.. pls see the sample file for the reference .. input and output.View attachment sample.xlsx
i Have dynamic range in A column which has serial number with blank cells underneath it.
For example, the serial in A3 range has 4 blank cells underneath it A3:A7, but coloured only from A3:A5...... i have many example like this .... i need a macro to copy the format only (colour) until the next serial number.. pls see the sample file for the reference .. input and output.View attachment sample.xlsx