Re: $$Excel-Macros$$ Finding Merged cells in excel

2011-09-20 Thread Rupesh Shrivastava
Hi, Can anybody suggest me the name of the Best book available in the market to learn VBA. Please suggest. I have already one book Excel 2010 Power programming with VBA , By- John Walkenbach Thanks in Advance Regards, Rupesh Shrivastava --

Re: $$Excel-Macros$$ Finding Merged cells in excel

2011-09-19 Thread Amit Gandhi
thanks alot sir. On Thu, Sep 15, 2011 at 5:47 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: To find a merged cell in Excel 2003. 1. Open a Find and Replace Menu. 2. Next to the Find What Field is a Format Box, Click it. 3. This opens the Find Format Menu screen which looks very similar

$$Excel-Macros$$ Finding Merged cells in excel

2011-09-15 Thread Amit Gandhi
Hi Folks I am finding some problem in excel data. Pls help me here. I have a excel data in 10 columns and 2 rows. There are some MERGED CELLS in this data. I am applying filters and its not working due to merged data. Is there any way in Excel to find merged cells automatically. Pls help me

Re: $$Excel-Macros$$ Finding Merged cells in excel

2011-09-15 Thread NOORAIN ANSARI
To find a merged cell in Excel 2003. 1. Open a Find and Replace Menu. 2. Next to the Find What Field is a Format Box, Click it. 3. This opens the Find Format Menu screen which looks very similar to the Cell Format Tabs and screens 4. On the Alignment Tab, remove any ticks in the Wrap Text or