HI Team,
I have three excel sheets, the first two sheets “one workbook” and two
workbook” each update every day and on cell “B” I need the number next to
4 to be moved to the end of main work sheet? Can someone help me out here
--
Join official Facebook page of this forum @
https://www
I use a VBA code to copy and paste lots of info but recently i get a error
message "Excel Cannot complete this tast with avaiable resources. choose
less data or close other application"
i tried just about everything and so far nothing works any recommendations?
--
FORUM RULES (986+ members
gt; Noorain Ansari
> ** <http://excelmacroworld.blogspot.com/>*http://noorainansari.com/*
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> On Wed, Mar 14, 2012 at 11:13 AM, LearnExcel wrote:
>
>> i'm using the following code to send email how do i add somet
Thanks guys I want to thank everone on this site for making us feel welcome
and open to answer any questions keep up the great work
On Wednesday, 14 March 2012 17:49:30 UTC-5, Ayush wrote:
> Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Fe
i'm using the following code to send email how do i add something to the
body?
does anyone know if its possible to add a message to the email?
ThisWorkbook.Sheets(1).Copy
With ActiveWorkbook
.SendMail Recipients:="emailaddr...@df.com", _
Subject:="Try Me")
hey Don, i didnt get the sheet can re-send it again
On Mar 9, 8:59 am, "dguillett1" wrote:
> I sent a “solved macro for this”
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> From: Selva Loganathan
> Sent: Thursday, March 08, 2012 8:31 PM
> To: excel-macros@go
hi guys this is the file can you please take a look
On Mar 8, 9:31 pm, Selva Loganathan wrote:
> -- Forwarded message --
> From: Selva Loganathan
> Date: Thu, Mar 8, 2012 at 2:07 AM
> Subject: copy range
> To: dguille...@gmail.com
>
> please look at sheet 1
>
> thank you for
ds.Range("a2")
> .AutoFilter
> End With
> End Sub
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
>
>
>
>
>
>
> -Original Message-
> From: LearnExcel
> Sent: Monday, March
>
>
>
>
>
>
>
> On Wed, Mar 7, 2012 at 8:16 AM, LearnExcel wrote:
> > help with code
>
> > Dim ws As Worksheet
>
> > can someone tell me why the follwowing code wont work
>
> > For Each ws In ThisWorkbook.Worksheets
> > If InS
Software
> dguille...@gmail.com
>
>
>
>
>
>
>
> -Original Message-
> From: LearnExcel
> Sent: Tuesday, March 06, 2012 8:24 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$ vba code to kill all open workbooks
>
> is there a VBA code th
help with code
Dim ws As Worksheet
can someone tell me why the follwowing code wont work
For Each ws In ThisWorkbook.Worksheets
If InStr(1, ws.Name, vbTextCompare) = 0 _
And InStr(1, ws.Name, "Doc", vbTextCompare) = 0 Then
Columns("C:C").EntireColumn.AutoFi
is there a VBA code that i can run that will kill all open
worksheets?
i open about 10 open excel files and once i'm done i want close all
work sheets WITHOUT SAVING.
i dont want any of my changes to affect the sheets can this be done?
--
FORUM RULES (986+ members already BANNED for violation)
On Mar 6, 8:30 am, Sam Mathai Chacko wrote:
> Will be easier if you attach a sample file
>
> Sam
>
>
>
>
>
>
>
>
>
> On Tue, Mar 6, 2012 at 5:51 AM, LearnExcel wrote:
> > Hi Guys/Girls i use VBA to copy a range using the following code
>
&g
Hi Guys/Girls i use VBA to copy a range using the following code
Selection.AutoFilter Field:=7, Criteria1:="bob"
ActiveSheet.Range("a1:o1", ActiveSheet.Range("a1").End(xlDown)).Select
the problem that i have is in cell "G" after the last cell there is a
3 lines of blank cell and then the report,
Thanks guys...works like a charm.
your all like angles but just more down to earth
On Mar 1, 1:14 pm, NOORAIN ANSARI wrote:
> Dear Selva,
>
> Please see attached sheet, hope your requirement is this.
>
>
>
>
>
>
>
>
>
> On Thu, Mar 1, 2012 at 10:43
quot;))
On Feb 29, 5:59 pm, "Asa Rossoff" wrote:
> =SUM(INDIRECT("'"&A6&"'!G:G"))
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of Lea
HI team, can you please help out on the following
I'm using a indirect function but i'm unalbe to get it to work in cell
"A6" if there ia name "sheet2" the forluma works just fine but when
the sheet name is "My Main File" it proivded an REF error is there a
rix for this?
=SUM(INDIRECT(A6&"!G:G
Hi team, i wanted to import data set from two files and consolidate
the data into a master file.
I need something in VBA, currently i run a marco that goes through
each sheet and copies them into the marco but for some reason it takes
some time im sure theres a better way..
let me know if you nee
this is the information that the forms takes
Name:
Credit Card #:
Phone #:
Problem: this is a drop down menu all I want this do is select the
3 option "help"
Notes:
ID:
Phone EXT:
computer Name:
On Dec 28, 9:24 pm, LearnExcel wrote:
> Good Day Friends
>
> I have a s
Good Day Friends
I have a small problem that i was hoping you can help out with
i have a excel file where i input some data. but i want the fields to
be automatically to populate a internet form which saves it
somewhere.
is there anyways to export this data set from excel to an internet
form muc
THANKS GUYS this works great
is there a way to set this up on VBA
On Dec 22, 1:07 pm, "Excel_Lover" wrote:
> See the attached File
>
> Rajan.
>
>
>
>
>
>
>
> -Original Message-
> From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
>
> On Behalf Of dguillett1
> Sent
21 matches
Mail list logo
