You can use dollor sign ($) to make any range fixed. For example, if you want to fix A1:A10, then you can write\use $A$1:$A$10....... one more example, if you want to sum data in Range A1:A10 and keep it fixed then use formula as =SUM($A$1:$A$10).......I hope this is helpful...for any other question write to exceldestination@gmail.com
how are u able to retain the same format after the merge? i did mine and the formatting is not the same like the borders are gone
Sir,, how to remove duplicates in data validation cell? Plse make videos on this
There is already a tutorial to remove duplicate. Please check following link :
th-cam.com/video/wIVNLRnyEuY/w-d-xo.html
Private Sub CommandButton1_Click()
Worksheets("Sales").Range("B2":F2").Merge
End
So your merge code only works on B2 and F2 cells?
Sir, if we want to merge multiple columns at 1 time what is d code for that?
Please guide, how can the range be made relative instead of fixed.
You can use dollor sign ($) to make any range fixed. For example, if you want to fix A1:A10, then you can write\use $A$1:$A$10....... one more example, if you want to sum data in Range A1:A10 and keep it fixed then use formula as =SUM($A$1:$A$10).......I hope this is helpful...for any other question write to exceldestination@gmail.com