RE: $$Excel-Macros$$ finding the last row

2010-10-31 Thread Dave Bonallack
Hi, The code line: Cells(Rows.Count, 1).End(xlUp).Row only finds the last cell in Column A, which is not necessarily the last row of data. Column C (for example) may have a lot more data in it than Column A. What kind of trouble have you had with ActiveCell.SpecialCells(xlLastCell).Select ? Re

RE: $$Excel-Macros$$ moving data to another sheet by using vba macro

2010-10-31 Thread Daniel
Hello, Try : Private Sub cmdMove_Click() Dim inCalculationMode As Integer Application.ScreenUpdating = False inCalculationMode = Application.Calculation Application.Calculation = xlCalculationManual Range("A6:I" & [A65536].End(xlUp).Row).Copy _ Sheets(

$$Excel-Macros$$ OPEN EXCEL - Needs your support and enthusiasm...

2010-10-31 Thread Ashish Jain
Dear Members, We're proud to launch OPEN EXCEL under the GNU Public License v3 which means it's available with source code to reach the maximum users around the globe with rapid development, more robust & innovative features. Since, public forums like these are hub of great professionals, knowledg

Re: $$Excel-Macros$$ moving data to another sheet by using vba macro

2010-10-31 Thread ashish koul
try this code see is it helps . Sub Macro1() Dim z As Long Sheets("Tambah").Select Range("A6").Select Range(Selection, Selection.End(xlDown)).Select Range(Selection, Selection.End(xlToRight)).Select Application.CutCopyMode = False Selection.Copy Sheets("Data

Re: $$Excel-Macros$$ manage lengthy database

2010-10-31 Thread Rajesh K R
Experts, Pls find the attachment and find a solution, in that filter not working properly in the dates except 10/10/2010 & 11/10/2010, pls tell me the problem & help me to solve it. Regards Rajesh kainikkara On 10/31/10, Rajesh K R wrote: > Experts, > Pls find the atta

Re: $$Excel-Macros$$ manage lengthy database

2010-10-31 Thread Rajesh K R
Experts, Pls find the attachment and find a solution, in that filter not working properly in the dates except 10/10/2010 & 11/10/2010, pls tell me the problem & help me to solve it. Regards Rajesh kainikkara On 10/30/10, ashish koul wrote: > Sub Macro1() > If ActiveSheet.A

Re: $$Excel-Macros$$ Macro to Go From One Cell to Another

2010-10-31 Thread Swapnil Palande
Hi, I am not able to understand ur question. pls make more clear.. and if possible give sample data Regards, Swapnil. On Sat, Oct 30, 2010 at 10:19 PM, MT wrote: > I have a worksheet called "Offering" and was wondering how do I make a > Macro to go from say cell C35 to E26 on that worksheet af

Fwd: $$Excel-Macros$$ How to consolidate the data using macro

2010-10-31 Thread bhavya khanna
Hi, Can someone sent me that in excel 2003 . because i have no 2007 . please send me that sheet in excel 2003 -- Forwarded message -- From: ashish koul Date: Thu, Oct 28, 2010 at 8:06 PM Subject: Re: $$Excel-Macros$$ How to consolidate the data using macro To: excel-macros@google

Re: $$Excel-Macros$$ Fwd: Practice

2010-10-31 Thread bhavya khanna
Hi, I need your help . i am also making form like this . but what is this object like object.list(row,column) and why we are consider column as zero and one On Wed, Oct 27, 2010 at 2:31 AM, Sergio Abadesso < groups.abade...@googlemail.com> wrote: > Hi Dave, > > you have to consider that the pro

Re: $$Excel-Macros$$ finding the last row

2010-10-31 Thread neil johnson
Hi, To Find the last non empty row try this syntax : dim lastrow lastrow = cells(rows.count,1).end(xlup).offset(1,0).row msgbox(lastrow) Or you can use Dim lastrow lastrow = Cells(Rows.Count, 1).End(xlUp).Row + 1 MsgBox (lastrow) step 2 ( if you want to color to last row) cells(lastrow,1).int