Thank you so much Ashish and Paul,
Trick working both of your guys.
Query is solved now
On Wednesday, June 3, 2015 at 12:16:44 PM UTC+5:30, Nasir Saikh wrote:
> Hi Experts,
>
> I need to help to make a excel database.
> In the excel file I need, users can open the sheet and add the data write
Did you get this worked out?In the attached file, prior to the file being
saved,any row that has data in column "A" is "locked" (and protected).
The user can add records to any other row and continue to modify the NEW
records until the file is saved.Once saved, the records are locked.
I used a Be
Try:
Sub Add_Rows() Dim R, nRows nRows =
Application.WorksheetFunction.CountA(ActiveSheet.Range("A:A"))
Application.ScreenUpdating = False Application.CutCopyMode = False For R
= nRows To 2 Step -1 Cells(R, "A").EntireRow.Insert Shift:=xlDown,
CopyOrigin:=xlFormatFromLeft
This method is an easier but roundabout to insert blank rows between
exiting rows. You can do as follows:
1. You need a blank column adjacent to your data. For example, I have a
worksheet comprises A1:E9, you can use column F.
2. In cell F1 input the number 1, and input 2 in cell F2.
3. Select t
Simple write numbers 1 to last row in column adjacent to your data and then
copy and paste those numbers below below as given below, sort your data
based on last column, it will show blank rows between each row.
For example
Column A Column B
A1
B 2
C
Dear Friends,
Please help me to insert blank/new row under each row using any macro.
Thanks
N.Sundarvelan
9600160150
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discusse
