HI Kamal,
Here is the sample workbook.
Regards,
Mrinal Saha
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN
Ashish, You are doing such a tremendous job...Keep going Bro.
regards,
Mrinal
On Sat, Apr 2, 2011 at 6:54 PM, Ayush Jain wrote:
> Hello Everyone,
>
> Ashish Koul has been selected as 'Most Helpful Member' for the month of
> March'11
> He has posted 48 posts in March 2011 and helped many people
Well, I don't see any big issue in the code.
Try putting j instead of (6+i) and remove the word "format" before End Sub.
regards,
Mrinal
On Mon, Apr 11, 2011 at 7:50 AM, Financeguy wrote:
> Hi All,
>
> I've got some code that's a bit buggy for a stock analysis
> spreadsheet, and in need of som
try this and paste it in code editor of the workbook you want to get
refreshed automatically.
Private Sub Workbook_Activate()
Application.Calculation = xlCalculationAutomatic
End Sub
On Wed, Apr 20, 2011 at 6:30 AM, JPK wrote:
> Hi,
>
> How to update the particular row in an excel when some
See the attached file, does it make sense..
regards,
Mrinal Saha
On Thu, Aug 11, 2011 at 10:37 AM, Amit Desai (MERU) wrote:
> 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 piv
are you sure your data is correct.. because none of the sim or mobile no
from last sheet matches to any of the sheet.
regards,
Mrinal
On Sat, Aug 27, 2011 at 4:10 PM, kannan excel wrote:
> Dear Guru,
>
>
> Pls find the attachment and help me.
> and i want vloopkup formulas.
>
> Your's
>
> kannan
Hey Folks,,
I have figured out a code to match the text file with excel sheet name.but
not able to open thetext file. Error in red line.
I want to open without using get openfilename.
Sub Read_text_File()
Dim fso, fld, fil As Object
Dim fldpth As String
fldpth = "C:\Documents and Settings\287
hi folks,
I have an excel sheet wherein column A contains EMP ID and column B contains
EMP NAME.
I also have an access database with multiple forms and each form contains
this two fields also out of many fields.
I want, if the EMP ID in form matches to column A in excel then highlight
the cell.
Hi Sandeep,
Save this attachment in the folder where you have all the workbooks and try
to run the macro (Button) on page 1 of this file.
Hope this helps,
Mrinal
On Wed, Nov 2, 2011 at 2:08 PM, wrote:
> Dear all,
>
> I have many work book in a single folder. I need a macro which if I run
> wi
try this...
If range("A1").value = " " Then
Exit Sub
Else
Range("B5").Value = 8
End If
End Sub
regards,
Mrinal
On Thu, Nov 10, 2011 at 9:18 PM, Seba wrote:
> Hi,
>
> I am testing this fairly simple code for some other purposes but I
> always get the value 8 regardless of value in A1:
>
> -
10 matches
Mail list logo
