Hi,
I was trying to copy the array formula from one column to another, but
the following macro only works for the last cell in the selection. Can
anyone please suggest how I can make the sendkey function to work for
every cell in the selection?
Thanks.
Sub copy_formulas2()
Dim aRng As Range
Dim
I know what the problem is -- I named the project and the function the
same. Once I named one of them differently, the function name gets
changed to normal.
On Feb 16, 9:39 am, Paul Qi wrote:
> I have made a UDF named "IsHardCoded" and saved as ".bas" file. I then
> opened a spreadsheet named "
What version of Excel are you using?
What you are referring to is called using "R1C1 reference style".
In Excel2007 it is found under Excel Options -> Formulas
and under the "Working with formulas" heading.
I'm not sure where to find it in older versions of Excel (perhaps you can searc
for R1C1)
I have an excel shett for which i wrote macro in VBA
the macro changes the cell address say : A! then It changes to B!
The macro is not working becuase the cell address has changed to R(2),C(1)
Any idea why the cell address has chanaged and how to change it back
Baloo
--
--
Please also note that the details of the venue are mentioned in the attachment.
They will be screening and interviewing on the spot with offers being
given THE SAME DAY.
All this is happening on 20th Feb.
So Hurry up.
On 2/16/10, gurumurthy sastry Kondury wrote:
> Hi All,
>
> I have been a pa
Try naming the table using a dynamic range formula.
Then refer to that range in the VLOOKUP function.
Dave
> Date: Mon, 15 Feb 2010 21:36:52 -0800
> Subject: $$Excel-Macros$$ vlookup reference automatic update
> From: pinankchh...@gmail.com
> To: excel-macros@googlegroups.com
>
> I have customer
