Hi Ashish,
Thanks for the reply. If u don't mind can u pls help me with the code which
has in attached excel file, because I am little bit confused with both the
codes.
Thanks in advance.
On Tue, Aug 9, 2011 at 2:32 AM, ashish koul koul.ash...@gmail.com wrote:
check this
- Original message
From:Bhilwara Infotech Limited ma...@bhilwarainfo.com
Date: 10 Aug 11 13:15:46
Subject: Job opening with Wipro for MIS Executive
To:
For Internal Use of Employer (Please don't delete or modify while replying
to this email)Monster Resume ID: 33564079
Hi,
In below code some times I could able to send attachments but some times its
not taking attachment at all. Please let me know whats is the problem in the
below code.
Sub sendmail()
'
Dim UserName As String
Dim MailDbName As String
Dim Recipient As Variant
Dim ccRecipient As String
Dim
What you want is doable with a macro. However, your “dummy” data does not give
data for testing to see what you really want. Redo your data and give a better
explanation of what you want. This to get you started
Application.Goto Sheets(3).Range(a2)
myname = Application.InputBox(Pick a cell Then
Attach a file with a better explanation and before/after examples
-Original Message-
From: AJ
Sent: Tuesday, August 09, 2011 2:20 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Locking cells based on conditions / todays date
There are dates in calendar order stored in row
Attach a file
From: Sundarvelan N
Sent: Tuesday, August 09, 2011 11:52 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Please help
Hi Friends,
Please refer the attached image. Please help on this scenatio.
Thanks
N.Sundarvelan
9600160150
--
Notice the sheet arrow keys at the bottom left. RIGHT click onevoila
-Original Message-
From: Dsastray
Sent: Tuesday, August 09, 2011 4:29 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Want a shortcut to browse tabs, alas, classic code
found is not working.
I would like
PLEASE HELP
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3.
Hello experts,
Let us assume in the particular cell i want a dropdown like south or north.
I will select anyone of it.If I select south In the next cell it
should show the AP,Tamilnadu,Karnataka
If I select North it should show the Maharastra, UP like that
can you please help me...
Regards,
See if it helps
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of naresh v
Sent: Wednesday, August 10, 2011 4:51 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Can you please help regd. lists
Hello experts,
Let us
Hi Naresh,
Based on your query i have attached the sample file for your reference.
Regards
Prakash Paul
On Wed, Aug 10, 2011 at 4:51 PM, naresh v naresh.veerabo...@gmail.comwrote:
Hello experts,
Let us assume in the particular cell i want a dropdown like south or
north.
I will select
See the attached sheet
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Jai
Sent: Wednesday, August 10, 2011 11:39 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ REMOVE THE ERROR IN THIS FILE
PLEASE HELP
--
Run this macro on your numbers and just use =e8+g8
Sub fixmynumsSAS()
Application.ScreenUpdating = False
'lr = Cells.SpecialCells(xlCellTypeLastCell).Row
On Error Resume Next
For Each C In Selection 'Range(a1:q lr)
If Trim(Len(C)) 0 And C.HasFormula = False Then
C.NumberFormat =
hi,
I need help with writing a macro which would copy selected range and
prompt me for target workbook, sheet and range. It would need to copy
only values and transpose them.
any help is greatly appreciated.
Regards,
seba
--
Dear Jai,
Please find simple solution without using Macro.
On Wed, Aug 10, 2011 at 11:39 AM, Jai jaihumtu...@gmail.com wrote:
PLEASE HELP
--
--
Some important links for excel users:
1. Follow us on TWITTER
Hi,
I am using a huge database of family and members, with column address /
DOB / Emp Code.
Now what I want, since the address and EmpCode is only agaisnt primary
member, so after executing command, I want that address should be filled in
each member of family
Jai,
Read this...
Error Checking Options
The Error Checking Options button is displayed when the formula in an
Excel worksheet cell triggers an error. In addition to the button, the
cell itself is marked with a small green triangle in the upper-left
corner.
When you click the
Hi,
I have data (numbers) in note pad, Around 1,000,000 line items. Can I
write a VBA code to copy data from Note pad to Excel? If yes, can
anyone advise me with Code?
Thanks and Regards,
Raghavendra
--
--
Some
Better option try press Ctrl + O then Select File type All Files
then select ur notepad file...
link
http://www.cpearson.com/excel/ImpText.aspx
On Wed, Aug 10, 2011 at 11:38 PM, Raghavendra raghavendra@gmail.com wrote:
Hi,
I have data (numbers) in note pad, Around 1,000,000
Post a file with a more complete explanation
-Original Message-
From: Seba
Sent: Wednesday, August 10, 2011 9:36 AM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ copy selected range to target with params
hi,
I need help with writing a macro which would copy selected range and
Hi,
This is driving me crazy, can someone help!
I have a nice pretty worksheet, all coloured in and stuff - all I want
to do is select all the cells and copy - then paste into a new
workbook.
I can do all of this, but it seems when using pastespecial I have to
select values (because these cells
what happens if you just rename the .txt file to .csv and open in Excel...
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
Hi,
Do you have any code so far that I can help you with or are you starting
from scratch?
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Great and very easy Option James
On Wed, Aug 10, 2011 at 11:46 PM, ja...@macstop.co.uk
ja...@macstop.co.uk wrote:
what happens if you just rename the .txt file to .csv and open in Excel...
--
--
Some important
don't worry, I worked it out using 2 lines of code, pastespecial values then
formats - would be nice to do it in one but I'm not that fussed... For some
reason I had convinced myself doing it a second time would wipe out the
number
--
Hey James,
If you want copy all cell ..then ..Just use Sheet copy and move
option then use paste special value function (Alt +E +M)
On Wed, Aug 10, 2011 at 11:29 PM, ja...@macstop.co.uk
ja...@macstop.co.uk wrote:
Hi,
This is driving me crazy, can someone help!
I have a nice pretty
thanks - it's a long story but basically I'm trying to export some sheets
from a workbook with loads of code behind it. I wanted to use move/copy
originally but it takes the vba behind the sheets with it. (Which I don't
want).
So I wrote a function that just deleted all vba code in the
Hello Naresh,
See the attached. You can Add/Delete New/Old entries.
HTH
Haseeb
For free help, visit,
http://www.excelfox.com/forum/forum.php
--
--
Some important links for excel users:
1. Follow us on TWITTER
Excel guru's, can I make a receipt file that adds 1 to a specific cell
everytime the file is opened?
Please see attached.
Thank you.
John
--
--
Some important links for excel users:
1. Follow us on TWITTER for
Hey Johnasmith,
Please find the attachment...
Code...
Private Sub Workbook_Open()
dt = Sheet1.Range(f2).Value
Sheet1.Range(f2).Value = dt + 1
End Sub
On Thu, Aug 11, 2011 at 1:24 AM, John A. Smith johnasmit...@gmail.com wrote:
Excel guru's, can I make a receipt file that adds 1
Hey Naresh,
Please find the attachment.
On Wed, Aug 10, 2011 at 4:51 PM, naresh v naresh.veerabo...@gmail.com wrote:
Hello experts,
Let us assume in the particular cell i want a dropdown like south or
north.
I will select anyone of it.If I select south In the next cell it
Itappears that this is only partially done. You need a worksheet_change
event macro tied to the dropdown cell to do the rest. How do you want the
list of cities displayed?
-Original Message-
From: XLS S
Sent: Wednesday, August 10, 2011 4:00 PM
To: excel-macros@googlegroups.com
or
Sheet1.Range(f2).Value=Sheet1.Range(f2).Value + 1
-Original Message-
From: XLS S
Sent: Wednesday, August 10, 2011 3:10 PM
To: excel-macros@googlegroups.com
Cc: John A. Smith
Subject: Re: $$Excel-Macros$$ Add 1 to a cell every time the file is opened
Hey Johnasmith,
Please find
Or with col 8 formatted as desired place this in the SHEET module
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row 2 Or Target.Column 7 Then Exit Sub
If UCase(Target) = DONE Then Target.Offset(, 1) = Date
End Sub
-Original Message-
From: XLS S
Sent: Wednesday,
To remove macros simply save as .xlsX
From: ja...@macstop.co.uk
Sent: Wednesday, August 10, 2011 2:24 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ PasteSpecial
thanks - it's a long story but basically I'm trying to export some sheets from
a workbook with loads of code
I now understand what you need. Have you gotten a satisfactory result yet?
From: Rajan_Verma
Sent: Wednesday, August 10, 2011 9:45 AM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Macro copy filter data in a new sheet
Please Ignore Previous Mail..
See if it helps
Hey James,
try this code for remove
Sub RemoveAllCode()
On Error Resume Next
'Make reference to Extensibilty Library
ThisWorkbook.VBProject.References.AddFromGuid _
{0002E157---C000-0046}, 4, 0
On Error GoTo 0
Dim VBComp As Object, AllComp As Object, ThisProj As Object
Dim
Hi Rajan,
It is not considering the country in any sheet while filtering the data.
Rest of the macro is fine and is working properly as I want.
On Wed, Aug 10, 2011 at 8:15 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
*Please Ignore Previous Mail.. *
*See if it helps*
* *
*Option
Did a search but got no hits.
I created a file in xl 2003 that included a button with some code
attached. I imported that file into xl 2010 and the button flashes on
and off quickly with no pattern. The code attached to the button still
runs; when I right click the button to assign properties it
Hi DH,
Please attach some sample data sheet...
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Thu, Aug 11, 2011 at 12:44 AM, Donovan Henderson
donovan.hender...@gmail.com wrote:
Good Day, Your Assistance needed:-
I have a spreadsheet showing the time of day particular categories of crime
Hi Dave,
Please ...Attach that workbook..
*Best Regards,*
*Venkat *
*Chennai*
On Thu, Aug 11, 2011 at 2:51 AM, DaveO dmo...@gmail.com wrote:
Did a search but got no hits.
I created a file in xl 2003 that included a button with some code
attached. I imported that file into xl 2010 and the
Dear All,
Please help me on the following;
1) I have created several pivot tables want to update the data source
range for all the pivot tables all together. (We do have option as refresh
all for applying the preset pivot criteria in all pivots.)
2) I have few work sheets where in I get the
42 matches
Mail list logo