Hi
Give this also a try.
sheet2.resize(sheet1.usedrange.rows.count,
sheet1.usedrange.columns.count).value = sheet1.usedrange.value
Regards,
Lalit Mohan
On Sat, Jul 14, 2012 at 1:12 AM, dguillett1 wrote:
> and then
> activesheet.shapes.cut
>
> Don Guillett
> Microsoft Excel Developer
> SalesAi
Hi,
Please attach file with sample data to make it more clear.
Regards,
Lalit Mohan
On Sat, Jul 14, 2012 at 3:11 AM, bpascal123 wrote:
> Hi,
>
> You say:
>
> I need your help again.We extract the data from database & each user got
>> some errors on different projects.I need to clean the error
Hi,
Can u provide the file to make it more clear.
Regards,
Lalit Mohan
On Sat, Jul 14, 2012 at 1:36 AM, hanumant shinde wrote:
> Hi friends.
>
> there is huge macro file which throws an error as "Cant exit design Mode"
> for few users at few occasions.
> we don't know when and why this error c
Hello,
There could be 1 of 3 things affecting this:
1. Is another application using that excel document? If so you will
not be able to edit it until the other application stops using it.
2. Is the file currently in a location that you do not have write
permissions? eg. another users shared docum
Dear
If you want a variabler such that it will works for all the procedure
in a module use below.
dim sh as worksheet
dim rng as range
Private sub abc()
set sh = Thisworkbook.Sheets("Sheet1")
set rng = sh.range("a1:c"&sh.range("c"&rows.count).end(xlup).row)
End sub
or else If you want it ac
Hi SG,
Please provide also a sample of the result you want. If your spreadsheet
has rows that do NOT have errors, include some of those in your sample as
well. If there are additional columns from the ones you included in the file
you already sent, please include them.
:)
Asa
From: excel-ma
Hi,
You say:
I need your help again.We extract the data from database & each user got
> some errors on different projects.I need to clean the error data to get the
> count of errors.For this,i do text to column on error column
What settings do you apply for text to columns?
If you first ch
*Hi,*
*Hope you are doing great today..*
*Please find the updated hotlist of my consultants..*
*Please send the requirements to she...@nityainc.com or feel free to call
me at 801-833-0416*
* *
*Consultant*
*Technology*
*Location*
*Relocation*
*Karthik*
*Oracle apps Finance functional cons
Hi friends.
there is huge macro file which throws an error as "Cant exit design Mode" for
few users at few occasions.
we don't know when and why this error comes but it was told us that this error
comes when we open Office 2003 file which has ActiveX control buttons in office
2007 version.
can
and then
activesheet.shapes.cut
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: NOORAIN ANSARI
Sent: Friday, July 13, 2012 1:47 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ VBA to copy the entire data without the button in
the sheet
De
Dear Vinay,
Please try
Sheets(1).copy after:=sheets(sheets.count)
On Fri, Jul 13, 2012 at 9:46 PM, t vinay wrote:
> Hi Team,
>
> Can any one help me with a vba code to copy the entire sheet into a new
> one without the button in that sheet.
>
> thanks for your help!!
>
> --
> Regards,
>
> Vinay
Hi Noorain,
unfortunatelly it won't help, but you give me some thoughts,
Thanks you it helps
Pawel
From: NOORAIN ANSARI
To: excel-macros@googlegroups.com
Sent: Friday, July 13, 2012 10:21 AM
Subject: Re: $$Excel-Macros$$ long opening file on the external
Hi Team,
Can any one help me with a vba code to copy the entire sheet into a new one
without the button in that sheet.
thanks for your help!!
--
Regards,
Vinay. T
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Plea
I think I'd skip the part about reading the "raw" data into the "Paste" Sheet.
Instead, I'd read from the text file and place it in the appropriate sheet.
A simple method would be like this:
Option Explicit
Sub ReadData()
Dim TDataFile, TextLine, TxtArray
Dim Sht, oRow, inx
TDataF
Hi Expert,
I am facing one issue with excel.
I open a excel workbook xyz.xlsm, it opens without any problem.
But when I closed only xyz.xlsm, and try to reopen it, i am getting message
that file is in read only mode.
I tried all option. but still no clue
What problem may be. can you experts give
Hello Group,
I'm attempting to automatically format a report that has several parts and
break it down to what I need.
The report comes in plain text and has three parts that all in with the
phrase "total :" in the last part of that section. I'd like to see about
having it break down each secti
Dear Hemant,
Pls declear variable as Public and it will declear out of pocedure
Like
Public abc as string
Sub A()
Abc="ram"
Msg abc
End sub
Sub B()
Abc="rahim"
Msg abc
End sub
Sent from BlackBerry® on Airtel
-Original Message-
From: Excel Vba
Sender: excel-macros@googlegroups.com
Date:
Hi Group,
Is it good practise to declare a global variable.
But, when i use global variable in loop it performs better.
Regards,
excelvba.lear...@gmail.com
Hi Sunnie,
Goto File Menu Bar, Click to options
On Thu, Jul 12, 2012 at 7:13 PM, Sunnie wrote:
> I received a spreadsheet that is using the R1C1 reference formula. If I
> turn turn off the R1C1 to apply the A1 reference will that then change how
> the formula works?
>
> Thanks !
>
> --
> FORU
Dear Sunnie
Uncheck R1c1 check box from file-Options-Formula.
Hope it should work
Regards,
Gawli Anil
On Fri, Jul 13, 2012 at 8:20 AM, Susan 1 <> wrote:
> Attached are the two spreadsheets. The one titled Aug2012 has the R1C1
> formula, the file ETS2011, is the data template for this year's en
Hi Group,
How can i declare a global variable for below mentioned.
Private sub abc()
dim sh as worksheet
dim rng as range
set sh = Thisworkbook.Sheets("Sheet1")
set rng = sh.range("a1:c"&sh.range("c"&rows.count).end(xlup).row)
End sub
In my module i have 20 procedure and in future comes ma
Dear Joseph,
>
>> Please try through Excel..
>>
>>
>>
>> =IFERROR(INDEX(Lists1,MATCH(0,COUNTIF($F$1:F1,Lists1),0)),IFERROR(INDEX(List2,MATCH(0,COUNTIF($F$1:F1,List2),0)),IFERROR(INDEX(Lists2,MATCH(0,COUNTIF($F$1:F1,Lists2),0)),IFERROR(INDEX(List3,MATCH(0,COUNTIF($F$1:F1,List3),0)),""
>>
>>
Hi Noorain,
Its working perfectly. I have tried this formulae for other sheets too.
Thanx alot...I need it for my report...
Have a wonderful weekend.
Sunita
On Fri, Jul 13, 2012 at 3:02 PM, NOORAIN ANSARI wrote:
> Hi Sunita,
>
> Please confirm..
>
> Is it not working..
>
> paste in Cell *E2*
if you can do then.
1. Clear all formatting you have done, and reformat all same(as was
initial) cell in just one step.
2. try to avoid array formula
3. Before open file set calculation mode manual
Divaker
On Fri, Jul 13, 2012 at 2:26 PM, pawel lupinski wrote:
> I'd like to do this but my k
Hi lupinski,
Please try it once again..
Option Explicit
Sub SHRINK_EXCEL_FILE_SIZE()
Dim WSheet As Worksheet
Dim CSheet As String 'New Worksheet
Dim OSheet As String 'Old WorkSheet
Dim Col As Long
Dim ECol As Long 'Last Column
Dim lRow As Long
Dim BRow As Long 'Last R
Please share the code.
Regards
Iqbal M
On Fri, Jul 13, 2012 at 5:15 AM, ChilExcel wrote:
> Hi Mohammed
>
> Please see attached file, I think is what you need
>
>
> Chilexcel
>
>
> 2012/7/12 Mohammed Hamed Ajaz
>
>> Pls help in conditional formatting
>>
>> Example
>>
>> Column A Colum
Hi Sunita,
Please confirm..
Is it not working..
paste in Cell *E2*
*=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))*
On Fri, Jul 13, 2012 at 1:22 PM, सुनिता पौडेल wrote:
> Hi,
>
> Still not working :(
> its 2010
>
> On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI > wrote:
>
>> Incase of
I'd like to do this but my knowladge is still not there, sad but true. Maybe
some other solution, please.
Regards,
Pawel
From: Divaker Pandey
To: excel-macros@googlegroups.com
Sent: Friday, July 13, 2012 9:40 AM
Subject: Re: $$Excel-Macros$$ long opening
try to calculate required calculation with the help of macros.
Divaker
On Fri, Jul 13, 2012 at 12:14 PM, pawel lupinski wrote:
> Hi All,
>
> I need your help on this issue. I have quite big file (21MB) that is doing
> a lot of calculation between tabs, in order to run this file more efficient
>
Thank you so muck Krishnaraddi ji. Still wondering where it went wrong.
Anyway thanks heaps.
Sunita
On Fri, Jul 13, 2012 at 1:53 PM, Krishnaraddi V. Madolli <
krishnaraddi.mado...@asia.xchanging.com> wrote:
> "CONFIDENTIALITY NOTICE: This message and any attachment are confidential
> and may al
Hi,
Still not working :(
its 2010
On Fri, Jul 13, 2012 at 12:04 PM, NOORAIN ANSARI
wrote:
> Incase of 2003
>
> You can also use..
>
> *=SUMPRODUCT(--($E$10:$E$46=$E$1)*($D$10:$D$46=C2))*
>
>
> On Fri, Jul 13, 2012 at 11:48 AM, NOORAIN ANSARI > wrote:
>
>> Hi Sunita,
>>
>> Please Try it..
>> =CO
31 matches
Mail list logo
