What I'm trying to do is have a function do some calculations and
display some result based on the row that its in. I couldn't find a
way to pass in the address of the cell into the function. row() is
exactly what I was looking for and it'll suit my needs.
Thank you!
On Jul 18, 1:08 am, JRF wr
You don't need a custom function just use the built in =row()
function
You could create a custom function to determine the row of a cell
reference
Function WhatsMyRow(TheCell As Range)
WhatsMyRow = TheCell.Row
End Function
and then in any cell type =WhatsMyRow(A1) the cell will show 1
On
Hi,
I pasted your code into my XL2000. I don't get any error when inserting rows.
Dave.
> Date: Fri, 17 Jul 2009 12:36:21 -0700
> Subject: $$Excel-Macros$$ DateStamp Macro Debug Help
> From: pogs...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> Hey all,
>
> I found a very simple macro to
This modified code seems to work
Public Sub Worksheet_Change(ByVal Target As Range)
If Target.Column = 1 Then
'Application.EnableEvents = False
On Error GoTo Errorhandler
Target.Offset.Offset(0, 13) = Now()
'Application.EnableEvents = True
End If
Errorhandler:
Is there a way to create a custom function that will print out row
number that the function is in?
For example, in cell C5, I'll type '=whats_my_row_number()' and I
would like it to say 5.
Thank you in advance,
--~--~-~--~~~---~--~~
--
Thanks ..I've never created Windows task manager..is there a link or
sample guide how to create task manager and .bat file?
On Jul 17, 2:43 pm, "Daniel" wrote:
> Hello.
> Use the OnTime command in your macro. This means that your workbook has to
> be open and your macro running at the activation
Hey all,
I found a very simple macro to track any changes made to any cell in a
row by datestamping the end of the row.
The issue comes in whenever i try to insert a row into the sheet, i
get an error: "Runtime Error 1004, Application-defined or Object-
defined error" and im not sure how to fix t
Hello.
Use the OnTime command in your macro. This means that your workbook has to
be open and your macro running at the activation time. However, if you use
Excel 2007, you could place the master workbook in a trusted folder (that is
to say that an auto open macro can run at open without security
I would suggest recording a macro that does all of the things
you want it to do.
Call the macro auto_Open.
At the end of the macro, add:
Activeworkbook.close SaveChanges:=true
save the workbook.
Next, create a windows Scheduled task that will open this workbook at 5:00pm
daily
(or weekday)
test
Hello,
Something new for me so need some help :
I' would like to have a macro which will extract data automatically
and daily from multiple workbooks ( Source ) and copy to Master
workbook ( target ) located under same network drive.
Say around 5 pm EST macro should auto run and complete the a
Use Hlookup instead
On 16/07/2009, Manoj Kukrej wrote:
>
> hI
> Can we look for fist column in **1**))>> vlookup(e3,r4:y4,1,0)
>
> Regards
>
> manoj
>
> --
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Dilip Pandey
Hi,
Try putting the following code in a module, then Run:
Sub ChangeToValue()
A = 2
Do Until Cells(A, 1) = ""
Cells(A, 1) = Val(Cells(A, 1))
A = A + 1
Loop
End Sub
Regards - Dave
Date: Thu, 16 Jul 2009 23:17:46 -0700
Subject: $$Excel-Macros$$ Value all the Selection
Hi Pooja
Yes, you are right about the disabling "Track Changes" query you raised in
your earlier mail. I missed out that feature. However, you may like to check
out the following sites to know more about writing a code (you can password
protect the same to prevent the macro from NOT running). Howe
Thanx dilip,
my problem is solved.
A learn a lot form u.
rgds,
Mahesh
On Fri, Jul 17, 2009 at 8:42 AM, Mahesh wrote:
> Hi Dili,
>
> Gud Morning,
>
> I using the same file which is already attached.
>
>
>
>
> On Thu, Jul 16, 2009 at 5:42 PM, Dilip Pandey wrote:
>
>> Dear Mahesh,
>>
>> It will
hi,
just copy the data in column A1 then take the curser in another cell , then
right click to curser , press paste special then select transpose then enter
ok
after these steps u get that data in differnt columns
regards,
swati
On Thu, Jul 16, 2009 at 6:36 PM, TAlgo wrote:
>
> _ Sept. 15, d
15 matches
Mail list logo
