see if it helps
Private Sub CommandButton2_Click()
Dim rng As Range
Dim i, j, c As Long
Dim wb As Workbook, srwb As Workbook
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
Set wb = ThisWorkbook
Set rng = wb.Sheets(1).Range("F1:F" &
wb.Sheets(1).Range("f65356").En
Hi David,
I was doing the same thing for last 3 months, but few days before I got
macro from this group itself which save my lot time.
Actully I have team of 60 members so its very difficult to distribute work
and collate it back.
Regards,
Amol
On 26 May 2012 18:01, David Grugeon wrote:
> Hi Am
Hi Amol
I have sometimes solved problems like this, by, rather than copying
part of the workbook, copying the whole workbook and then deleting the
parts i did not want in the copy. I do not know if this approach
would work for you.
Regards
David grugeon
On 26/05/2012, Amol Jadhav wrote:
> Hi
Hi Rajan,
Thanks for quick reply
Some part of work is done. Still problems remain same like -- In splitted
files if you check validation is not working, If you check in main
file range G:i there is validation and values comes from validation sheet.
I want same validation in splitted workbooks, so
