Hi friends,
I want to select the visible cell range each time and border it outside up/down/left/right side. The cell range changes each time because the new data is enter in the table.
Friends, please suggest me a code for it. My programme is ready only this code is require to complete it.
The cell range starts from b2 to n... each time changing 'n' and row number.
Thanking you.
Sincerely,
Mukesh
Last edited by mukeshbaviskar; 12-22-2013 at 11:09 AM.
Hi, Mukesh,
maybe
IŽd take care to check if there is data available by checking the last visible row in Column B prior to copying:
Please Login or Register to view this content.
if row 2 is the row with the headers.Please Login or Register to view this content.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hi friends,
I want to select the visible cell range each time and border it outside up/down/left/right side. The cell range changes each time because the new data is enter in the table.
Friends, please suggest me a code for it. My programme is ready only this code is require to complete it.
The cell range starts from b2 to n... each time changing 'n' and row number.
Thanking you.
Sincerely,
Mukesh[/QUOTE]
Hi Holger,
Extremely sorry for mistake. Due to technical problem there are 2/3 repeted posts. I edited the post because I want to border the visible range.
Please apologize me.
Thank you for your quick response with solution. Please give me a code for corrected question.
Sorry and thank you.
Sincerely,
Mukesh
Hi, Mukesh,
I canŽt see any reason for placing borders around an ever changing range, IŽd go with a list/table there. If there are really hidden rows inside the area extra lines will be set.
Ciao,Please Login or Register to view this content.
Holger
Hi Holger,
Excellent! The code is working fine and giving correct output. I want to color the border so I added a line of code but it is not working. I want to color the border purple.
Please see it and tell me where I'm wrong.
Thank you.
Sincerely,
Mukesh
Hi, Mukesh,
ColorIndex 1 is black, you would need to set the color there like
Ciao,Please Login or Register to view this content.
Holger
Hi Holger,
Excellent! It's working fine as per my requirement.
Thank you for giving me a solution which gives the output in a single line than mine multiline code. I learned a simple code to set border today.
Thank you very much.
have a nice day!
Sincerely,
Mukesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks