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 @
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
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
://noorainansari.com/*
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Wed, Mar 14, 2012 at 11:13 AM, LearnExcel sendse...@gmail.com wrote:
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
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 dguille...@gmail.com 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:
hi guys this is the file can you please take a look
On Mar 8, 9:31 pm, Selva Loganathan sendse...@gmail.com wrote:
-- Forwarded message --
From: Selva Loganathan sendse...@gmail.com
Date: Thu, Mar 8, 2012 at 2:07 AM
Subject: copy range
To: dguille...@gmail.com
please look
-
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 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
, Mar 7, 2012 at 8:16 AM, LearnExcel sendse...@gmail.com 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 InStr(1, ws.Name, vbTextCompare) = 0 _
And InStr(1, ws.Name, Doc
Software
dguille...@gmail.com
-Original Message-
From: LearnExcel
Sent: Monday, March 05, 2012 6:21 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ copy range
Hi Guys/Girls i use VBA to copy a range using the following code
Selection.AutoFilter Field:=7, Criteria1:=bob
On Mar 6, 8:30 am, Sam Mathai Chacko samde...@gmail.com wrote:
Will be easier if you attach a sample file
Sam
On Tue, Mar 6, 2012 at 5:51 AM, LearnExcel sendse...@gmail.com wrote:
Hi Guys/Girls i use VBA to copy a range using the following code
Selection.AutoFilter Field:=7
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)
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.AutoFit
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,
once
))
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of LearnExcel
Sent: Wednesday, February 29, 2012 2:34 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ indirect function help
HI team, can you please help out on the following
Thanks guys...works like a charm.
your all like angles but just more down to earth
On Mar 1, 1:14 pm, NOORAIN ANSARI noorain.ans...@gmail.com wrote:
Dear Selva,
Please see attached sheet, hope your requirement is this.
On Thu, Mar 1, 2012 at 10:43 PM, LearnExcel sendse
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
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
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 sendse...@gmail.com wrote:
Good Day Friends
I have a small
THANKS GUYS this works great
is there a way to set this up on VBA
On Dec 22, 1:07 pm, Excel_Lover rajanverma1...@gmail.com wrote:
See the attached File
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of
21 matches
Mail list logo
