obj

Hi! I would like to get all text value on a worksheet into one variable. I managed with cells, its obvious. ... Sheets(Sheets.Count).Select For Each cell In Range("A11:EE500") t = t & " " & LCase(cell.Value) Next cell... But stucked with other object which should have text value. So far i...

Hi All, I have below columns :- 1) Posting Date(Column I) 2) Total quantity(Column U) 3) Value in Obj. Crcy(Column V) 4) ESIGNAM(Column AG) Now in column AK I want to below mentioned logic :- For example A is repeated 3 time with 3(1-jan, 2-jan,3-jan) different posting dates, then I have...

Hi all, I'm currently designing a scorecard in work which gives a certain weighting for several objectives... OBJ 1 - 10% OBJ 2 - 5% OBJ 3 - 7.5% etc, etc Some cells contain words, such as outstanding, achieving, developing, etc & I've been able to give a % weight to each of these with this...

Hi All, I am facing a problem while sorting a group of Objects according to their values. When multiple values entered are same, then Only the First Object is being returned thrice. While I want all the objects to be returned with same values. Please help. Demo...