ContributionsMost RecentMost LikesSolutionsRe: how to search for contents,copy text from one excel file to another excel in vbscript I am trying to find Range on columns in vbscript Excel1.Sheets("sheet1").Columns.Range("A4") Object not supported error is displayed. Can any1 help? I need to Go select the entire column range,search and find the cell index where text is present . Then search for a new column name(say Name/id) ,goto the same index and paste a new text in that cell. Re: issue in selecting values from drop down HiLeandro de Araújo Souza, That worked for me. Thanks a ton. Regards, kavya v Re: issue in selecting values from drop down Throws RunTime error issue in selecting values from drop down I have to select values from dropdown iteratively and im using the following code. I can get the full name of the dropdown item but storing the value in a varaible and using it doesnot work Can any1 please tell where i went wrong.?? for i=0 to 1 Aliases.RCWinTrans9.wndRCWinTransX8Class.MDIClient.Acti_9_Smart_Test.Item.splitbuttonLanguages.dropdownbuttonOpen.Click 'To get the full name of dropdown item iteratively name=NameMapping.Sys.RCWinTrans9.Item.GetUnderlyingObject.Child(i).FullName 'log full name of the child in the dropdown 'This is working absolutely fine log.Message(name) Aliases.RCWinTrans9.wndRCWinTransX8Class.MDIClient.Acti_9_Smart_Test.Item.splitbuttonLanguages.dropdownbuttonOpen.Click /I am trying to click on the name ,but this throws runtime error name.click Re: how to search for contents,copy text from one excel file to another excel in vbscript Thank you that was great help. how to search for contents,copy text from one excel file to another excel in vbscript say i have two excel files ,file1 and file2. file1 has coumn1-name/id,column 2-text in chinese,col3-text in french etc. now i have to search if name/id of file1 is present in file2. if present i need to copy contents of col2-text in chinese to file2 respective cell. can any1 help me do this in vbscript.? I am new to text complete and dont have much idea on this. Thank you