Can you send an example sheet ... or paste and example here
On Thursday, March 22, 2012 12:13:35 AM UTC+5:30, Raj Mahapatra wrote:
>
> hi all
>
> i am looking for some vba codes which will search html files (bases file
> names in the sheet) from specified locations and paste the path of the same
Hi Bheema,
Please refer to the link below this should help you understand this in the
future.
http://office.microsoft.com/en-us/excel-help/create-edit-and-manage-connections-to-external-data-HA010167227.aspx
On Tuesday, March 20, 2012 10:21:58 AM UTC+5:30, Bheema Shankar wrote:
>
> Dear Expe
Hi Sandeep,
My code below assumes the following
1. The serial numbers are in column A
2. The Excel version you are using is 2007.
3. The code is good for 10,000 rows. Please modify if required.
Sub Serial()
Dim i As Long
For i = 1 To 1
If Cells(i, 1) <> "" And Cells(i + 1, 1) <> "" Then
middle of 3 and 7.
Regards,
Damimkader S. Meeran
On Thursday, March 22, 2012 1:50:18 PM UTC+5:30, sandeep chhajer wrote:
>
> Dear Damimkader,
>
> while I am running this code I am getting the follwing error code
> run time error 13
>
> type mismatch
>
> please hel
nd If
Next i
End Sub
Regards,
Damimkader
On Thursday, March 22, 2012 4:37:19 PM UTC+5:30, sandeep chhajer wrote:
>
> Dear Damimkader S. Meeran,
>
> Thanks for your reply.
> With ref to your question:
>
> I use office 2010 version.
>
> And I wan
Hi,
Please review the below link it is very helpful with simple examples.
http://www.free-training-tutorial.com/animations/conditional-formatting-examples.html
Regards,
Damimkader S. Meeran
On Thursday, March 22, 2012 8:05:32 PM UTC+5:30, vnrao wrote:
>
>
> Hello Experts,
>
Hi,
I checked the VBAVlookup custom function, it is looking up using usernumber
and the layout on the Txtlist sheet. If this is slowing down the
performance of the application, I would recommend creating a column which
concatenates the usernumber and layout column on the "txt list" sheet and
o
Alerts = False
ActiveWindow.SelectedSheets.Delete
Application.DisplayAlerts = True
Sheet1.Select
For k = i + 1 To i + (Diff)
Range("A" & k & ":C" & k).Select
Selection.FillDown
there are questions.
Regards,
Damimkader S. Meeran
On Friday, March 23, 2012 7:04:18 AM UTC+5:30, Jim Schug wrote:
>
> Hi,
> I'm nearly brain dead (tired) and can't think straight. I have a simple
> issue. A macro to fill in blank values if found with the value from the
Hi,
In the workbook open module please write the following code
Private Sub Workbook_Open()
UserForm1.Calendar1.Value = DateTime.Date
End Sub
Regards,
Damimkader S. Meeran
On Friday, March 23, 2012 10:03:44 PM UTC+5:30, Raj Mahapatra wrote:
>
> hi group,
>
> i want date in cale
Hey,
I understand that you need to find out unique values, but it is very
necessary that you want to use countif ... coz this is a better way to
do it. Sort all values in column A and then use a simple if formula =IF
(A2=A3,"",1) ... to get unique values.
Please let me know if that does not serv
Hey,
I couldnt find a place to upload the excel workbook with the popup
calendar, so i've sent u a mail. I hope it helps.
On Sep 17, 10:47 am, Prashant Pednekar wrote:
> HI
>
> Dose any one have pop up calender in excel cell.
>
> Regards,
> Prashant.
--~--~-~--~~~--
Can u send a sample sheet with the grouping this can be done with
a macro.
On Sep 17, 7:27 am, subs wrote:
> hi
>
> I would like to add a couple of empty rows at the end of each grouping
> in a spreadsheet. i.e instead of adding any subtotals, i would like to
> keep two rows empty at the en
Hi,
I think this might help you .
http://support.microsoft.com/kb/289270
Regards,
Damimkader S. Meeran
On Sep 25, 1:08 am, Subu wrote:
> In
> In MS Excel, is it possible to assign different passwords to different cells
> on same worksheet?
> The intention is to allow users to ed
Hi Tony,
I think this is what you may need.
Right Click the Shape
Select Hyperlink
Click Screen Tip
Type in your message
Click OK
Click Bookmark
Type A1 in the top box
Click OK
Click OK
On Oct 1, 9:13 am, Tony Bender wrote:
> I have an Excel application and on my 'front end' I would like to
>
15 matches
Mail list logo
