mohanvijay
03-18-2011, 08:44 PM
Hai,
I am trying to add comments into cells line by line like below
Sl No Name age
--------------------------
1 vijay 25
--------------------------
2 kannan 30
i set space for "SL no" to "name" 30 and "name" to "age" same 30
and i write code to make each line the code does if lenth of name < 30 then add spaces upto lenth 30 also for age and using vblf const for next line the string variable gets as above and last i set that variable to addcomment method
that works properly but the problem is the size of letters and spaces not same my code result like this
Sl No Name age
--------------------------
1 vijay 25
--------------------------
2 kannan 30
--------------------------
3 muruganmur
--------------------------
4
28
how to i correct this or make same size for each letters and spaces
please help
I am trying to add comments into cells line by line like below
Sl No Name age
--------------------------
1 vijay 25
--------------------------
2 kannan 30
i set space for "SL no" to "name" 30 and "name" to "age" same 30
and i write code to make each line the code does if lenth of name < 30 then add spaces upto lenth 30 also for age and using vblf const for next line the string variable gets as above and last i set that variable to addcomment method
that works properly but the problem is the size of letters and spaces not same my code result like this
Sl No Name age
--------------------------
1 vijay 25
--------------------------
2 kannan 30
--------------------------
3 muruganmur
--------------------------
4
28
how to i correct this or make same size for each letters and spaces
please help