vidya lakshm
09-02-2010, 04:42 AM
PFA the sheet which has a partial VBA code written
I have a button in sheet4. On the click of button, sheet1 would get filled with the contents
I would need your help/clarifications regarding the following queries w.r.t Excel VBA
Q1 ) How do I identify the unique values in a column – to be specific of column C?
I want to rename a sheet(Sheet1) based on this unique column value. How do i go about it?
Q2)How do I dynamically merge cells based on the number of cells that have value after column F in sheet 4 ?
i.e. merge D3-G3 in Sheet1
L3-N3 in Sheet1 and so on
I need to mention the method name in sheet4 as the column value for merged cell in sheet1.
Hoping for a favorable reply at the earliest. Thanking you in anticipation.
I have a button in sheet4. On the click of button, sheet1 would get filled with the contents
I would need your help/clarifications regarding the following queries w.r.t Excel VBA
Q1 ) How do I identify the unique values in a column – to be specific of column C?
I want to rename a sheet(Sheet1) based on this unique column value. How do i go about it?
Q2)How do I dynamically merge cells based on the number of cells that have value after column F in sheet 4 ?
i.e. merge D3-G3 in Sheet1
L3-N3 in Sheet1 and so on
I need to mention the method name in sheet4 as the column value for merged cell in sheet1.
Hoping for a favorable reply at the earliest. Thanking you in anticipation.