I have customer record file in My Main pc. & backup in another pc. To
update my old data I’m using vlookup function it’s working but problem
is there when any new name will be come I have to type the name
manually and its not possible for me to find a new record and than
update coz data is more tha
Have you tried this:
With the workbook active, go to the VB Editor (Alt+F11) and under the Tools
menu select References. If any checked references have a (Missing) in front
if them, uncheck it.
Krgrds,
AJ
On Mon, Feb 15, 2010 at 6:08 PM, fill brain wrote:
> Hi all,
>
> i have a few functions
Hi, RaHul,
MS office 2007 if using very easy to learn bcz in help u can see the
clipings and u easy to learn the pivot tables and charts it is very
easy.
Best Regards,
Venkatesh Narla.
On Mon, Feb 15, 2010 at 1:38 PM, RAHUL SUREKA
wrote:
> Hii,
> I want to learn Excel Micro,Macro a
Hi,
I figured out my earlier macro query today. I used the below code and
it worked! So, no need to spend time on getting a solution.
Thanks!
For k = 1 To 40
If ActiveSheet.Cells(i + 1, k).HasFormula = False Then
ActiveSheet.Cells(i + 1, k).ClearCo
Hi Ayush/Moderators,
Below is the code you had given me. I changed it to extend the range
and also changed the fixed cell.
All works well, but it is not clearing the contents of the new row
beyond column "Z". If I make the k value larger (instead of 1 to 25, I
put 1 to 37 as I want it till column
Hi Rahul,
You could go through the below links provided by this group. They are
very useful! In your case, check out 2,3 and 4.
Regards,
Shivam
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins download
Hi all,
i have a few functions in my excel and i was try to change some values
with replace (CTRL + H) and after when i close to workbook and when i
open it again it was give to me "Error in loading DLL" and that is
blocked to save my workbook and that function dont working...
how can i solve tha
Hi Keith,
You can force the upper-case by using the 'UCase' VBA function on the 'Target'
You can then remove the lower-case Cases.
Private Sub Worksheet_Change(ByVal Target As Range)
Set I = Intersect(Target,
Range("I9:AM58,I66:AM115,I124:AM173,I182:AM231,I240:AM289"))
If Not I Is Nothin
*hiii*
*Please Reply me how to use the excel file for windows media player and it
asking for a password also.*
On Thu, Feb 11, 2010 at 9:07 PM, Harmeet Singh wrote:
> *Hi Guyzzz*
> *
> *
> *I found a great tool on internet.*
> *You can control Window Media Player usi
Hi Keith,
Would you please send the Excel file where the changes are required ?
Best regards,
Ayush Jain
On Feb 15, 7:41 am, Keith wrote:
> I consider myself a self-taught novice user of VBA for Excel. I took
> on a project at work and developed this VBA code with the help of the
> internet to
Hii,
I want to learn Excel Micro,Macro and pivot table and the
Advanced Function.Please help me out how can i learn.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and
hell,
I want to learn Excel Micro,Macro and pivot table and the
Advanced Function.Please help me out how can i learn
On Sun, Feb 14, 2010 at 1:17 PM, Ayush wrote:
> Hi Niraj,
>
> It is developed by Ashish Jain...Please contact him at 26may.
> 1...@gmail.com
>
> Thanks and Best r
12 matches
Mail list logo