Posts by prem

Re: Add spaces to a string

can u please tell me how to start a new thread

Re: Help with Custom Formats..Please!!!!

but when i used

[>=10000000]#\,##\,##\,##0.00;[>=100000]#\,##\,##0.00;##,##0.0

and typed 22121121212

i got 2212,11,21,212.00

starting four digit should have been 22,12.

why it stopped formatting after 7 digit from right?

in other words, all the number should have same length to use this format. if the lenght is more then the last digits will not get formatted,

Re: Help with Custom Formats..Please!!!!

mr anand is right it is not working

any please advice how to bring this format

Re: Insert row based on cell value

Quote from Derk

I'm a bit unclear as to exactly where you want the lines inserted, but try the following and adjust as needed.
[vba]
Sub InsertSome()
Dim i As Integer, n As Integer, m As Long
n = ActiveCell.Value - 1
m = ActiveCell.Row - 1
For i = 1 To n
Rows(m + 2 * i).Insert
Next i
End Sub
[/vba]

Display More

the third line given by Mr.Derk should be

n = ActiveCell.column - 1
instead of
n = ActiveCell.Value - 1