copying 2 columns in one sheet, to all other sheets (except 2 sheets)

Try

Please Login or Register  to view this content.

thank u my friends

playaller, if i wanna add one more excluded sheet like "infopage", its name is "extracost"

how we should modify it for not applying this code to two sheets: "infopage" and "extracost" ???

waaaaay my neighbor Fotis!!!!
how are u : )))))) thank u so much for helping me always, 7/24 : )))))

infact Fotis, i have one more problem with this code !
when i run this code, its working only with the *.xlsm file where its saved , its not running in other excel files which is opened in that time beside this *xlsm file.

this error comes from this part in code : "For Each ws In ThisWorkbook.Sheets" ???

Try one of these lines

Please Login or Register  to view this content.

tamam AB33 !!!
it worked
thank u so much!!!

fotis, how u could write macro to Xls file ? : ))))) cant macro codes be stored only with xlsm files ?

Originally Posted by Fotis1991

xlsb and xlsm are files(with macros) that exist for Excel >=2007.

Before 2007 all the files were in xls format(with OR without macros).

ah i see, U love 2003 more : ))))))))

then then one more macro, pls write to me : )))))))
let me tell : )))

in the workbook, there is sheet name called "market" .

i want to delete all columns in this sheet, after row 120 .
i want to keep the rows 1-120 , delete down all of them

what is the macro code of this? : )

ahhaha he realy got bored with easy and low-profile macro wishes : )))))
tamam i ll try that FOTSİSSSSS : )))