er you can.” - John Wesley
-------------
From: deanalt via MS EXCEL AND VBA MACROS
>To: excel-macros@googlegroups.com
>Sent: Friday, July 18, 2014 9:18 PM
>Subject: $$Excel-Macros$$ run-time error '1004': Reference is not valid.
>
>
>
I sent someone an EXCEL macro enabled workbook file (created in EXCEL 2010)
and they ran some macros, saved the result, then later tried to run a
different macro and got the error message in the subject line. I had no
such problem in running it just the way they did it on my computer. It is
l the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
>
> From: Rupesh Patil
>To: excel-macros@googlegroups.com
>Sent: Thursday, January 2, 2014 3:07 AM
>Subject: $$Excel-Mac
Dear Rupesh,
Kindly share the workbook with us.
Warm Regards,
Gawli Anil
On Thu, Jan 2, 2014 at 1:37 PM, Rupesh Patil wrote:
> Hi expert
>
> Please look below code and tell me why I am getting this error(Mentions in
> subject line)
> Private Sub ComboBox1_Click()
> Select Case ComboBox1
Hi expert
Please look below code and tell me why I am getting this error(Mentions in
subject line)
Private Sub ComboBox1_Click()
Select Case ComboBox1
Case "CAP"
pre_Med_Name_1.List = Range("CAP").Value
Case "CREAM"
pre_Med_Name_1.List = Range("CREAM").Value
Case
after u declare variables use
on error goto abc
and before end sub
abc:
exit sub
use error handlers
http://www.xlpert.com/partG.htm
http://www.functionx.com/vbaexcel/Lesson26.htm
On Thu, Auon errg 11, 2011 at 1:16 PM, Andy McGooner <
andrew_mcni...@yahoo.co.uk> wrote:
> Hi All,
>
> I hav
Hi All,
I have a spreadsheet that stores data from a text file, the idea being
that it opens the file dialog and i select the relevant text file. The
problem is that when i do the file open and press cancel i get the
folowing message:
Run-time error '1004'
false.xls could not be found
How do i
The following macro should activate worksheet Matrix Table then print
out some text and then print out the values in the Nstep_tran array.
Since I don't have a row counter, I am in the process of working out
the formula for the Else case. What follows Else is a place holder.
I cannot get the init
=False
>
> > Regards,
>
> > Deepak Rai
>
> > On Tue, Dec 1, 2009 at 10:03 AM, Dave Bonallack
> > wrote:
>
> > > Hi,
> > > Try doing it manually with the macro recorder on, then look at the syntax.
> > > Dave.
>
> > > > Da
alse, Transpose:=False
>
> Regards,
>
> Deepak Rai
>
> On Tue, Dec 1, 2009 at 10:03 AM, Dave Bonallack
> wrote:
>
>
>
>
>
> > Hi,
> > Try doing it manually with the macro recorder on, then look at the syntax.
> > Dave.
>
> > > Dat
der on, then look at the syntax.
> Dave.
>
> > Date: Mon, 30 Nov 2009 10:05:31 -0800
> > Subject: $$Excel-Macros$$ Run-time error '1004': PasteSpecial method of
> Range class failed
> > From: jon.wester...@gmail.com
> > To: excel-macros@googlegroups.com
>
&
Hi,
Try doing it manually with the macro recorder on, then look at the syntax.
Dave.
> Date: Mon, 30 Nov 2009 10:05:31 -0800
> Subject: $$Excel-Macros$$ Run-time error '1004': PasteSpecial method of Range
> class failed
> From: jon.wester...@gmail.com
> To: exce
This is something that seems pretty simple, I am trying to paste
values into a workbook using a macro:
Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteValues
I start out by manually copying a range of cells in a separate
workbook and clicking a form button to paste the values. Each time
13 matches
Mail list logo
