Fwd: $$Excel-Macros$$ Merged Cells autofit row height

2010-07-07 Thread Iqbal Muneeb
Urgent help is required. Please help! -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.

$$Excel-Macros$$ Extracting Embedded Word documents from Excel

2010-07-07 Thread Iqbal Muneeb
Dear Experts! Hi. I have a big Excel file where over a 100 places, there are Embedded Word Documents. I want to extract all such embedded documents on a separate sheet and remove the embedded documents from Excel. Kindly help Regards! -- Have a good day! Muneeb Cell: 0300 2213043 -- ---

$$Excel-Macros$$ Merged Cells autofit row height

2010-07-06 Thread Iqbal Muneeb
Dear Experts. I am working on a huge file where some cells have been merged. I need to autofit the row height of the merged cells. A code I have copied from the WEB does not work. Kinldy have a look at it or please suggest a new one. Code is as follows. Regards. Private Sub Worksheet_Change(ByV

Re: $$Excel-Macros$$ Cell Capacity & filters

2010-07-06 Thread Iqbal Muneeb
Thanks for your reply. That is what I am doing and it is combersome. What I want to know is as follows 1.ithere some VBA codes whereby the capacity can be enhanced from 255 charachters; or Excel 2010 would solve this problem ( I have Excel 2007). -- Have a good day! Muneeb Cell: 0300 2213043 -

$$Excel-Macros$$ Cell Capacity & filters

2010-07-05 Thread Iqbal Muneeb
Hi Dear ones. I need help. Cells have a capacity of 255 characters, beyond which filters do not work. Is there a wayout. I have a file where certain cells have very long strings; they donot show up in the filter. Please guide me. Thanks. -- Have a good day! Muneeb Cell: 0300 2213043 -- --

$$Excel-Macros$$ Deleting Empty Rows

2010-06-11 Thread Iqbal Muneeb
Hi Dears Your kind help is needed. How to delete empty rows from a huge table. The data is scattered in the table. -- Have a good day! Muneeb -- -- Some important links for excel users: 1. Follow us on TWITTER for t