Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Macro

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

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
Found","OK"),"")


& 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

Share: 

 

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.




Tagged: