Hi
Try this..put this code in worksheet module for which this to be work, this
will delete content of column 3, you can set to desired column:
*Private Sub Worksheet_SelectionChange(ByVal Target As
Range)Columns(3).ClearContents 'clears content of column 3End Sub*
*Cheers!!*
*O*n Tue, Feb 24
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, F
Dear neeraj,
PFA,
Regards,
Ganesh N
On Tue, Feb 24, 2015 at 10:40 AM, Neeraj wrote:
> Dear experts,
>
>
>
> I want to SUM of time as given below format
>
>
>
> *2/1/2015*
>
> *2/21/2015*
>
> *sum in Hours*
>
> *Like*
>
> 11:39:49
>
> 9:42:15
>
>
>
> 9 hrs 30 Minute
>
>
>
>
>
> *From:* Neeraj
Superb Vaibhav. Thanks for sharing this with us.
Regards
Gaurav Devrani
On Mon, Feb 23, 2015 at 11:25 PM, Chandan Bisht wrote:
> Hi.
>
> Very nice...
>
> Thankx & Rgds,
>
> Chandra Singh Bisht
>
>
>
> On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi wrote:
>
>> Convert all date in same format:
>
Hi.
Very nice...
Thankx & Rgds,
Chandra Singh Bisht
On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi wrote:
> Convert all date in same format:
>
> While receiving data from different sources many time it happens that
> data received is not in same format due to various reason.
>
> One of the
Dear experts,
I want to SUM of time as given below format
2/1/2015
2/21/2015
sum in Hours
Like
11:39:49
9:42:15
9 hrs 30 Minute
From: Neeraj [mailto:neerajchauhan...@gmail.com]
Sent: Tuesday, February 24, 2015 10:11 AM
To: 'excel-macros@googlegroups.com'
Subject: Help req
Dear experts,
I want to some of times as given below format
2/1/2015
2/21/2015
sum in Hours
Like
11:39:49
9:42:15
9 hrs 30 Minute
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
Hi all,
I'm pulling data from an Access DB query table. When I do, it changes the
name of the active worksheet and I don't want that. How to I pull the data
but keep the tab name as it was? Here's the code I'm using:
ChDir "G:\Work Program\2015"
Workbooks.OpenDatabase Filename:= _
*Hi Sal Sal,*
Please find the attached macro file.
Regards,
MV
On Monday, February 23, 2015 at 10:32:27 PM UTC+5:30, Sal Sal wrote:
> Possible to show a toltiptext on mouse over on each items of combobox?
>
> Note:
> combobox is on a vba useform
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT))
kumar i got it what you sent. it's open with alt+f11 not ctrl+f11
now i want this only one specific column not on all sheet. can you please
send formula for that
On Mon, Feb 23, 2015 at 7:43 PM, Ahmad Mustfa wrote:
> i want this in a specific column not on all sheet
>
> On Mon, Feb 23, 2015 at
i want this in a specific column not on all sheet
On Mon, Feb 23, 2015 at 7:40 PM, Ahmad Mustfa wrote:
> Thanks kumar.
> how you did that. i am still confused? how i can use in my work? can you
> please have online chat with me.
>
> On Mon, Feb 23, 2015 at 7:22 PM, Suresh Kumar B <
> bsureshkuma
Thanks kumar.
how you did that. i am still confused? how i can use in my work? can you
please have online chat with me.
On Mon, Feb 23, 2015 at 7:22 PM, Suresh Kumar B
wrote:
> Hi Ahmad,
>
> Here you go!!!
>
> By,
> Suresh Kumar.B
>
> On Tuesday, February 24, 2015 at 12:45:22 AM UTC+5:30, Ahmad
Hi Ahmad,
Here you go!!!
By,
Suresh Kumar.B
On Tuesday, February 24, 2015 at 12:45:22 AM UTC+5:30, Ahmad Mustfa wrote:
>
> Thanks Kumar.
> Can you please send me in the excel file. i am trying but unable to
> understand to how to do that.
>
> On Mon, Feb 23, 2015 at 6:59 PM, Suresh Kumar B >
Thanks Kumar.
Can you please send me in the excel file. i am trying but unable to
understand to how to do that.
On Mon, Feb 23, 2015 at 6:59 PM, Suresh Kumar B
wrote:
> Hi Ahmad,
>
> Please follow my instructions to clear what do you want,
>
> Steps:
> 1. Goto to Excel page, Press CTRL+F11
> 2.
Hi Ahmad,
Please follow my instructions to clear what do you want,
Steps:
1. Goto to Excel page, Press CTRL+F11
2. After that, in the left hand side shows the sheets menu, Double click
that after paste the following code.
*Private Sub Worksheet_SelectionChange(ByVal Target As Range)*
*Dim r As
Hi All.
I am working in excel sheets . I want to automatically delete/clear text in
a cell range. i am not expert enough to do that. Can anyone please help me.
Thanks
--
Regards,
Ahmad Mustafa
+44 7768197568
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,
Possible to show a toltiptext on mouse over on each items of combobox?
Note:
combobox is on a vba useform
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORU
Option Explicit
Sub export_range_delimit()
Dim arr As Variant
Dim fs As Object
Dim delimittxt
Dim i As Long
Dim j As Long
Dim line As String
Dim rng As Range
Dim delimittype As String
delimittype = ","
Set fs = CreateObject("Scripting.FileSystemObject")
Do you wanna export range in comma delimit text file?.
On Mon, Feb 23, 2015 at 9:38 PM, Muneera Shabana
wrote:
> Hello there,
>
> I have written a macro to convert xls files to text file, however I have 2
> problems here:
> 1. My code doesnot show xlsx format to pick up from the source folder
>
Hello there,
I have written a macro to convert xls files to text file, however I have 2
problems here:
1. My code doesnot show xlsx format to pick up from the source folder
2. I am not sure when to add the code to have delimiter "comma" in my text
file.
I am not an expert, so seeking support fr
Try this in B5 of sheet2 and drag right.
=IF((COLUMN()-1)<=Sheet1!$B$3,Sheet1!$B$2,IF((COLUMN()-1)=Sheet1!$B$3+1,SUM(OFFSET($A$5,,1,,Sheet1!$B$3)),""))
On Mon, Feb 23, 2015 at 7:29 AM, Gaurav Devrani
wrote:
> Yes Sure.. I will get back to you with that formula. No worries.
>
> Regards
> Gaurav
Convert all date in same format:
While receiving data from different sources many time it happens that data
received is not in same format due to various reason.
One of the tedious activity is to transforming data to same format.
I will share very good technique to convert all dates to same for
Yes Sure.. I will get back to you with that formula. No worries.
Regards
Gaurav Devrani
On Mon, Feb 23, 2015 at 7:25 AM, Enock Wangila wrote:
> Hi Gaurav,
>
> Thank you for you help. Quick question, is there a way of using a formula
> instead of a code to do what you have done. Maybe an If stat
Hi Gaurav,
Thank you for you help. Quick question, is there a way of using a formula
instead of a code to do what you have done. Maybe an If statement of some
sort. Would appreciate if that were possible. I really need a formula.
On Mon, Feb 23, 2015 at 4:42 PM, Gaurav Devrani
wrote:
> Hi ,
>
>
Hi ,
I guess you also want to merge the header cells in sheet 2 for all
entries.. Please refer to this new sheet.
Regards
Gaurav Devrani
On Mon, Feb 23, 2015 at 6:19 AM, Gaurav Devrani
wrote:
> HI Enock,
>
> Please check the attached file and let me know if I missed something.
>
> Regards
HI Enock,
Please check the attached file and let me know if I missed something.
Regards
Gaurav Devrani
On Mon, Feb 23, 2015 at 5:08 AM, Enock Wangila wrote:
> Hi Guys,
>
> I want a formula that populates values in a worksheet, on a single row
> based on two values entered on a different worksh
Thank you for your reply.
I have full access of my computer, there is no restriction of IT.
I will try for it.
On Wed, Feb 18, 2015 at 6:22 PM, Paul Schreiner
wrote:
> Do you have admin privileges for the machine?
>
> Windows has "policies" that you can assign to a machine.
> These Policies ca
Hi Guys,
I want a formula that populates values in a worksheet, on a single row
based on two values entered on a different worksheet. The formula should
then sum the populated cells and input the result in the cell adjacent to
the last cell entry. Example: I want to fill 9 cells in sheet2 with
28 matches
Mail list logo