Hi David,
many thanks for your answer. where i should insert your line?
regards
Fede
On 30 Lug, 01:24, Dave Bonallack davebonall...@hotmail.com wrote:
Hi,
Try this line of code:
Cells(ActiveCell.Row, Columns.Count).End(xlToLeft).Offset(0, 1).Select
Regards - Dave.
Date: Thu, 29 Jul
Hi Vasant,
I have sent an email to you with regard to the date ranges. Please refer
that mail and do the needful. Thanks a lot for your help.
Regards,
Sharma
On Thu, Jul 29, 2010 at 10:31 PM, Vasant vasant...@gmail.com wrote:
Hi,
The Recd Date and Completion date is differs for each
Mr Abhishek Jain,
There is problem with the function when the following dates are given.
29/01/2010
30/01/2010
31/01/2010
Please check and modify it.
Regards,
Kishan Reddy, K
On Jul 30, 9:47 am, Abhishek Jain abhishek@gmail.com wrote:
You're welcome.
However, both works. 1st one is
hi
there is a problem in opening an excel file with macros...wht should be done
to open the excel file with macros?
pls rply soon..it is urgent
--
Pooja
--
--
Some important links for excel users:
1. Follow us
Which version of Excel are you using??
In Excel 2003:
To allow unsigned macros to run, the *Trust all installed add-ins and
templates* check box must be selected on the *Trusted Publishers* tab of the
*Security* dialog box. This option is selected by default. If it is not
selected (recommended),
Dear Pooja
Pls find below the steps to be taken to enable the macros in MS Excel.
1. Click the *Microsoft Office Button* [image: Button image], and then click
*Excel Options*.
2. Click *Trust Center*, click *Trust Center Settings*, and then click *Macro
Settings*.
3. Select the options *Enable
Hello,
Let me know,
How many number of REPs are there?
Why do you want to put them in different sheets?
Regards,
Kishan Reddy, K
On Jul 29, 2:11 pm, Venkatesh Narla nvenki...@gmail.com wrote:
Hi,
Can u check this this can be helpor not
On Wed, Jul 28, 2010 at 11:21 PM, Ahmed Honest
attach the form, let me check.
Kishan Reddy, K
On Jul 28, 10:16 pm, b wer61...@gmail.com wrote:
I have an Excel workbook w/ a VBA menu to pops up a userform to write
values back to a worksheet in the workbook. Sometimes, the userform
locks Excel and it has to be abended. I suspect its due to
HI
If you are using excel 2003
Click on Tools-Macro-Security
and then select Medium
and close the file and open the file again.
If you are using excel 2007
Click on Office Button
Goto Excel Options, select Trust Center, select Trust Centre Settings,
select Macro Settings, check on Enable All
The solution was sent through mail.
Is the solution working fine, reply back.
Regards,
Kishan Reddy, K
On Jul 29, 8:33 am, Nagendra Modupalli naga14...@gmail.com wrote:
Hi Team,
The password is correct STPIInvoices in this up to STPII is CAPS letter
nvoices is small latters.
Please let me
Kishan
Thanx, for your help.
But kindly tell me if i save macro in This Workbook,
Will it work for other workbooks.
REHAN
On Wed, Jul 28, 2010 at 11:53 AM, Kishan Reddy, K
kishanreddy.kethire...@gmail.com wrote:
Instead of storing the macro in personal macro workbook, select this
2003 h/..but jo apne bataya vo already tha ..but fir b macros nai h
On Fri, Jul 30, 2010 at 2:16 PM, Aindril De aind...@gmail.com wrote:
Which version of Excel are you using??
In Excel 2003:
To allow unsigned macros to run, the *Trust all installed add-ins and
templates* check box must be
Hello All,
I have a collumn called problem, in that collum i recieved a mapped value
but it is doing it wrong.
I need the formula to get the highest value in *Kgs* Column (criteria
same *date*, same *code_number)*.
Based on the *Kgs *Maximum value, it has to get the *code* on the left
Hello,
I urgently need to get the maximum value from Kgs column. But i have
specific criteria, they have to have same Date and same Code_number.
How can i do this?
Thanks for you help and regards
--
--
Some
Hi,
This is a stand-alone line. Just put it in a module and run it from a button or
keyboard shortcut. Or you can use it inconjunction with other code.
But try it alone first, to see if it does what you need.
Sub FirstEmptyCellActiveRow()
Cells(ActiveCell.Row,
Please see if you can resolve the below code..It use to run perfect,
but now fails the last statement:
Sub patron_RetrieveData()
Dim ns As Outlook.NameSpace
Dim fld As Outlook.MAPIFolder
Dim itm As Object
Dim msg As Outlook.MailItem
Dim ex As Excel.Application
Dim
Hello,
Thanks for the feedback, could you please help me out do a lookup.how
can i retrieve the code attached to each maximum. The code column is on
the left and for example ...the first column max 901 is related to code
107, how can i get that code!
Regards and thanks!
2010/7/30
HI,
Hope this helps
pls run the macro ALign in the attached file.
Data in Sheet1 is aligned in Sheet2. I hv copied the code for your
convenience.
*Sub Align()
Dim Wksht As Worksheet, NWksht As Worksheet
Set Wksht = ThisWorkbook.Worksheets(Sheet1)
Set NWksht = ThisWorkbook.Worksheets(Sheet2)
Hi,
Try this out.
Sub Macro1()
'Assumes data starts in cell A1
Columns(A:A).Select
Selection.Insert Shift:=xlToRight
Range(B1).Select
Selection.Cut
ActiveCell.Offset(2, -1).Range(A1).Select
ActiveSheet.Paste
Selection.Copy
ActiveCell.Offset(1, 0).Range(A1).Select
Would really appreciate if you give others some time to think.. Thanks !!
~Cheers,
Krishnan Moorthy
P Please consider the environment before printing this e-mail.
ツ♫♪
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On
Behalf Of Nadine S
Sent: Friday, July
Is there a way to find a duplicate with 3 criteria? I know it can be done with
one. Assuming there is data in columns A, B, C. I need to find if there are
any duplicates that match all three in those columns. Thanks.
--
Hi,
Is it possible to crack the password for the excel window.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
22 matches
Mail list logo