MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds


  Asked By: Gene    Date: Sep 30    Category: MS Office    Views: 1262

how are u All

i am looking help for 2 problems

kindly help me!

i got 2 worksheets, actuly those are monthly reports,

what i need to do is

i have to define a Macro by which my 200 Sheets & my each sheets have 5-6
merge cells

1) what i need that any code which AUTOMATICLLY REMOVE the Merge cells & make
it Left Justify

2) i have a code

=IF(B7>0,IF(ISNA(VLOOKUP(B7,'C:\Documents and
Settings\Sajjad\Desktop\done\[Feb2007.xls]KHi - Main'!$B$7:$B$500,1,0)),"Not

& i want to paste this code automaticcly on my each sheets till 500th Room

one thing is to note that both worksheets have same Sheets name

is this possible that i dont have to go & paste the same FUNCATION to each
Sheet & change the Sheets name

rather use a macro to do this task



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Macro Or get search suggestion and latest updates.