Search results

Hi Narayan, Thanks for your mail I have downloaded yr file and try to run macro it the same but still facing problems. I have replied your mail with error print shoot. Regards, Pragnesh

Hi Narayan, could you send me excel file with ready code to my mail address: pragnesh_50@yahoo.in Because i am uanable to run macro successfully as it gives error viz., vriable are not define. Regards, Pragnesh

Hi Narayan, I get Compile error: Variable not defined. for current_raw = Regards, Pragnesh

Hi Narayan, I am unable to judge where to add above coded ....as i not regular user of codes... Is it possible for you to give me whole new code. Regards, Pragnesh

Hi Narayan, I have readymade macro having three macro buttons. Button1 Number Commets-- which give number to cell comments like 1,2,3,...etc Button2 clear Number-- which is used to remove number given to cell comments. Button3 List Comments--gives output in new sheet having columns like...

Hi Narayan, This time error code is 9. Subscript out of rang. If i put "On Error Resume Next" just before about line and try to run macro again than i get Run time error '438': object doesn't support this property or method. and line "Wrong_Value = Range(current_address).Value3" in yellow...

Hi Narayan, I i am getting error as followes: "Run-time error '1004': No cells were found." In module follwing line is highlited in yellow back ground when i click Debuge option. Range(Start_Range, End_Range).SpecialCells(xlCellTypeComments).Activate Thanks, Pragnesh

Hi Narayan, Thanks again for Quick response. yes i want exactly what you have mentions. a) The Product Code corresponding to which the comment was made b) The column label ( whether the correction was for BRAND1 , BRAND2 ,... ) where the correction was made c) The correct entry , as...

Hi Narayan, Fist at all thanks for your valuable feedback. Label of respective column is in Fist raw of sheet (ex. sheet2) contains various characteristic type of product such as BRAND1, BRAND2, BRAND OWNER INTERNATIONAL, WEIGHT, GROSS WEIGHT ETC.... My fist column in same sheet contains...

Hello, If any cell contains comment(insert comment)than my output should be label of that respective column and value of fist cell of that raw. (All such comments are in sheet1) I want this output in another sheet which content address of all cells having comment in sheet1. Regards, Pragnesh