Re: $$Excel-Macros$$ Solution plse

2011-05-07 Thread NAJEEB JAFRI
When copying excel files, the following problems: PROBLEM 1 1). The settings of the Margins are getting disturbed PROBLEM 2 Also when you take a print out, the @age of the page fluctuates Do you or your friends have any solution Please revert Thanks & regards -- ---

Re: $$Excel-Macros$$ Solution plse

2011-05-03 Thread NOORAIN ANSARI
Dear Hemant, Please try it.. Sub InsertSpecificRows() Dim InsQuan As Integer On Error Resume Next InsQuan = InputBox("Enter number of rows to insert", "Your Call") If InsQuan <= 0 Then MsgBox "Invalid number entered", vbCritical, "Stop!" Exit Sub End If Application.ScreenUpdating

$$Excel-Macros$$ Solution plse

2011-05-03 Thread Hemant
Hi   I have a data in cells and and want to add Blank cells to existing data such that every alternate cell will be empty.   e.g. 1 2 3  To 1 Blank 2 Blank   Thanks -- -- Some important links for excel users: 1. Fol