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
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(
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
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
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
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
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
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
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
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
10 matches
Mail list logo