Try This :
Sub DeleteRow()
LastDataBased = 5
LastRow = Range("A" & Rows.Count).End(xlUp).Row
Range("A" & LastDataBased).Resize(LastRow, 1).EntireRow.Delete
End Sub
Sub DeleteCol()
LastDataBased = 5
LastCol = Cells(1, Columns.Count).End(xlToLeft).Column
Cell
Thanks man it works!
Cheers
On Tue, Aug 23, 2011 at 10:45 AM, Rajan_Verma wrote:
> *Try this :*
>
> * *
>
> *Sub InsertRow()*
>
> *For i = 13 To 22 Step 4*
>
> *Range("A" & i + 1).Select*
>
> *Range("A" & i + 1).EntireRow.Insert*
>
> *ActiveCell.Value = "Product breakdown"*
>
> *Next*
>
> *End
Dear Umar,
Please use below code to insert row on specific area...
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
A
Try this :
Sub InsertRow()
For i = 13 To 22 Step 4
Range("A" & i + 1).Select
Range("A" & i + 1).EntireRow.Insert
ActiveCell.Value = "Product breakdown"
Next
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Umar Abeer
Sent: Tuesday, August
HI satish
See the Below Link :
http://excelpoweruser.blogspot.com/2011/07/embaded-flash-object-in-excel.htm
l
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of jasmin
Sent: Tuesday, August 23, 2011 11:54 AM
To: MS EXCEL AND VBA MACRO
Dear All,
Please let me know how to delete multiple rows(say from my last data based row
# 678 to last row) & multiple columns (say from AA to last column).
This is taking a lot of file size...
Best Regards,
Amit Desai
Disclaimer: This message and its attachm
Hi Ashish,
I am getting an error while running the code which was given below could you
please send me the worked attchment plz
Thanks
Prasad
Sent from BlackBerry® on Airtel
-Original Message-
From: ashish koul
Sender: excel-macros@googlegroups.com
Date: Tue, 23 Aug 2011 11:35:59
To:
Hi everybody,
I need to insert rows at specific intervals in multiple sheets & copy texts
to those insertions. For example, after row 14 18 & 22, I want one row
inserted & copy text "Product breakdown" to a14, a18, a22.
I have 50 sheets in my workbook with the same format, so I need it to loop
t
hi experts
can any body explain how to insert and auto play flash file in excel
2007.I download one flash file from fire fox and inserted in to
excel .I fulfilled all property correctely but msg shows file not
loded.
if any one have example file please send me.
Thanks in advance
satish
--
add this macro to each box
Sub test()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
' method 1 in this u have to change the shape names as per the sheet names
'For i = 2 To Sheets.Count
'Sheets(i).Visible = True
'If Sheets(i).Name <> Application.Caller Then
'
'Sheets(i).Vi
Hi All,
I was trying to write a macro which is not working well, attached is the
sheet where is require a small code the below is the what i require:
I have a main sheet which is assgined with controls and i have 5 TABS , what
i want is when i click on the first control named with Sheet1 in the m
-- Original message --
From:"Metriqe Solutions"< care...@metriqe.com >
Date: 22 Aug 11 21:33:06
Subject: Openings for Data Analyst in Metriqe Solutions (MNC)
To:
Cc: care...@metriqe.com
Dear Candidate,
Greetings from Metriqe Solutions Pvt Ltd (MNC)!!
*Metriqe Solutions is a Busi
Thanks Daniel for your kind and prompt help.
But unfortunately I am not familiar to using Macros. Can you please
guide me in using this Macro.
Thanks again.
Regards,
Bhargava Raju
On Aug 22, 4:16 pm, "Daniel" wrote:
> Try :
>
> Sub FromTable1()
>
> Dim Rg As Range, Tabl, lgRow As Long
>
> Set
Thanks all for the help
Problem got resolved,
Regards,
Kaushik
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN gr
use this...
=INT(ROUND((BC3-BD3),1)) then put filter
On Mon, Aug 22, 2011 at 10:21 PM, rajan verma wrote:
>
> see if it helps
>
> On Mon, Aug 22, 2011 at 10:00 PM, XLS S wrote:
>
>> because it's not a right condition not equal to 0.00..please try
>> it self ...just copy and paste spice
because it's not a right condition not equal to 0.00..please try it
self ...just copy and paste spicel and check cell value..
On Mon, Aug 22, 2011 at 9:50 PM, KAUSHIK SAVLA wrote:
> Hi All,
>
> I want hello in filtering data.
>
> In attached file if I am applying in Column BE Filter, the
http://akoul.blogspot.com/2011/07/sending-birthday-images-messages-to.html
try the attachment
On Mon, Aug 22, 2011 at 8:21 PM, dguillett1 wrote:
> Sounds a bit like “homework”
>
> *From:* pankaj gmail account
> *Sent:* Sunday, August 21, 2011 11:01 PM
> *To:* excel-macros@googlegroups.com
Try :
Sub FromTable1()
Dim Rg As Range, Tabl, lgRow As Long
Set Rg = Range([B6], Cells(6, 2).End(xlDown)).Resize(, 5)
Tabl = Rg
lgRow = 5
For i = 1 To UBound(Tabl)
lgRow = lgRow + 1
Cells(lgRow, 10).Resize(3) = Tabl(i, 1)
Cells(lgRow, 11).Resize(3) = Tabl(i, 2)
Cells(lg
I sent the original answer. I should have told you to save your file as an
.xlsM (macro enabled file)
From: Sundarvelan N
Sent: Monday, August 22, 2011 6:59 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Please help
Hi Team,
Still i'm notable to find the solution for t
Sounds a bit like “homework”
From: pankaj gmail account
Sent: Sunday, August 21, 2011 11:01 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Automatic Birth Day Outlook Mail Message
Dear Group,
Can you people help me I want to create a Excel based Birthday Mail which will
autom
- Original message
From:""Benvia software (India) Pvt. Ltd""< sravanthi.ko...@benvia.com >
Date: 22 Aug 11 16:02:21
Subject: Immediate RequirementofMS ACCESS and Excel Database Programmer for
Chennai &Mumbai location
To:
The sender of this email is registered with Naukri.com as Be
Dear Brother
Sorry i can't see
Tariq
On 19 August 2011 14:23, NOORAIN ANSARI wrote:
> Dear Tariq,
>
> I have attached Excel sheet in trailing mail.
>
> --
>> Thanks & regards,
>> Noorain Ansari
>> http://noorain-ansari.blogspot.com/
> On Fri, Aug 19, 2011 at 11:14 AM, Tariq Aziz wrote:
>>
>>
The sender of this email is registered with Naukri.com as Helios Matheson
It Ltd.
*Dear Candidate,*
HI,
Greetings from Helios & Matheson IT Ltd.,
We are a leading healthcare focused IT services company. We are a public
limited company listed in NASDAQ, NASCOM, and BSE. We provide consulting and
Dear experts,
I need help in excel ASAP. The attached is a excel file which contains data.
I usually given Table 1 or Table 2 and needs to be changed to the Table 3
format. The data in the attached file is very less. But in real time I would
be given data containing some 5000 to 8000 line items wi
Dear All,
PFA sample file for your kind consideration.
Regards,
AMW-2
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
>
> Hi Team,
>
> Still i'm notable to find the solution for this task. Please find the
> attachments.
>
> Thanks
> N.Sundarvelan
> 9600160150
>
>
>
> On Thu, Aug 11, 2011 at 3:18 AM, dguillett1 wrote:
>
>>
>> Or with col 8 formatted as desired place this in the SHEET module
>>
>> Private Sub Wor
Ayush,
This is Free only the site is Below
http://www.pdftoexcelonline.com/
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Mon, Aug 22, 2011 at 9:54 AM, Ayush Jain wrote:
> Venkat,
>
> If the tool is free ware, Please feel free to share with entire group. I
> can see individuals asking to se
Hi All,
PFA...
http://www.pdftoexcelonline.com/
-- Forwarded message --
From: Venkat CV
Date: Sat, Aug 20, 2011 at 3:33 PM
Subject: Re: $$Excel-Macros$$ how to change a pdf file in to excel
To: excel-macros@googlegroups.com
Hi Anil,
Check the website..
http://www.pdftoexcelo
Hey Anwar,
It would be very helpful if your data could result in an actual case with a
real example.
On Mon, Aug 22, 2011 at 2:26 PM, Anwar Mohd wrote:
> Hi Rajan,
>
> I need the Summary tab in Quarter wise only.
>
> Regards
>
> Anwar
>
>
>
> -- Forwarded message --
> From: Anw
29 matches
Mail list logo
