hey
you missing additional control..
Your cells are not locked, lock & then protect..
Cheers//Vabs
On Sun, Jun 30, 2013 at 3:44 PM, Pravin Gunjal wrote:
> Hi Experts,
>
> I have assigned the macro to attached file for protect and unprotect the
> sheet manually. But it is not working properl
Hi
It is not possible, by default Graph or Image is fixed to a place.
Check whether your range is freezed. Un freeze pane by Pressing ALT + W + F
If problem persist share your sheet.
Thanks
On Sat, Jun 29, 2013 at 12:33 AM, santosh subudhi <
santoshkumar.subu...@gmail.com> wrote:
> Hi Team,
d as you
> say and didnt work. So i tried to change With
> ThisWorkbook.Worksheets("sheet1")
>for With ThisWokbook.ActiveSheet or With ActiveWorkbook.ActiveSheet,
> neither of them worked. I dont want to run it on a module where I have to
> initialize the macro every time
ank cells, for now
> everything is perfect. Thank ou so much for your help. Soon I'll need more
> help on a similar subject, I hope you can Help. Now I'll try to fit in my
> real sheets. Have a nice weakend
>
>
>
> 2013/6/28 VBA VABZ
>
>> Hi
>>
>
Hi
Either your table is corrupted, re-created new excel file using pasting
values.
Best Luck.
On Thu, Jun 27, 2013 at 11:45 AM, thameem wrote:
> Still getting hanged, even it was converted in to binary file, i tried to
> delete empty rows, but not working
>
>
> On Thu, Jun 27, 2013 at 9:55 AM
box, i want that range programmatically.
>
> Divaker
>
>
> On Tue, Jun 25, 2013 at 6:19 PM, Divaker Pandey wrote:
>
>> thanks for your quick response.
>>
>> but i couldn't get, please vabz tell me exact way, how can i get data
>> range used by chart.
>
HI
Pl refer:
http://msdn.microsoft.com/en-us/library/office/aa213736%28v=office.11%29.aspx
Using the ChartArea Object
Use the *ChartArea* property to return the *ChartArea* object. The
following example sets the pattern for the chart area in embedded chart one
on the worksheet named "Sheet1."
Wo
Pl consider this.
On Tue, Jun 25, 2013 at 1:13 PM, VBA VABZ wrote:
> See this sheet as per your requirements.
>
> Pl let us know if any error.
>
> HTH//Vabs
>
>
> On Mon, Jun 24, 2013 at 8:14 PM, VBA VABZ wrote:
>
>> Hi
>>
>> Refer hope this will
See this sheet as per your requirements.
Pl let us know if any error.
HTH//Vabs
On Mon, Jun 24, 2013 at 8:14 PM, VBA VABZ wrote:
> Hi
>
> Refer hope this will help.
>
> http://chandoo.org/wp/2010/09/10/working-hours-formula/
>
>
> Thanks
>
>
> On Mon, Jun 24
Hi
PFA file that take care of coping data.
HTH//Vabs
On Mon, Jun 24, 2013 at 7:41 PM, wrote:
> Hi All!
>
> My name is Ryan. I am pretty experienced in Excel but have run into a
> dead in with my recent project. I currently manage all PO's for my company
> to perform financial formulas, analy
handra
>
> On Mon, Jun 24, 2013 at 7:10 PM, VBA VABZ wrote:
>
>> HI
>>
>> Can you give more clarity. What date1 & date2 means here.
>>
>> Thanks
>>
>>
>> On Mon, Jun 24, 2013 at 6:22 PM, Chandra Shekar <
>> chandrashekarb@gmai
HI
Can you give more clarity. What date1 & date2 means here.
Thanks
On Mon, Jun 24, 2013 at 6:22 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> I need a formula which calculate dates based on working hours please find
> attached file.
>
> Regards,
>
> Chandra
>
>
>
> --
>
n :
>
> Use the below
> =TEXT(DATE(RIGHT(B4,4),MID(B4,4,2),LEFT(B4,2)),"DD-MMM-")
>
>
> On Sat, Jun 22, 2013 at 3:15 PM, Pravin Gunjal wrote:
>
>> Dear Vaibhav
>>
>> It's not working,. please check the attachment.
>> Thanks,
>&g
re might be somewhere setting is changed.
>
> Regards
> Pravin Gunjal.
>
> ------ Forwarded message --
> From: VBA VABZ
> Date: Sat, Jun 22, 2013 at 5:06 PM
> Subject: Re: $$Excel-Macros$$ Web links in word - reg.
> To: "excel-macros@googlegroups.com"
HI
Open new word doc & try pasting there.
If it works there then there is issue in existing doc so you need to
re-create existing doc.
HTH//Vabs
On Sat, Jun 22, 2013 at 4:50 PM, Prabhu Pinky wrote:
> hi pravin,
>
> am also using the same version of MS Word. But its working fine even if i
> pr
Hi
For end time you can add one line ti check existing time with end time, if
existing time is > end time then quit sub.
HTH//Vabs
On Sat, Jun 22, 2013 at 10:57 AM, Bill Q wrote:
> Sounds good Vabz Half way there. What about the end time ? Where would
> that go ?
> On Friday, June 21, 201
Select cell, right click, format cell, custom & type DD--.
You can use text(cell,"DD-MMM-") also.
Thanks
On Sat, Jun 22, 2013 at 1:31 PM, Pravin Gunjal wrote:
> I have date in this format : *DD.MM.* (with dot) and require it as : *
> DD-MMM-* (with hyphen).
> For example :
try edate formula..
Thanks
On Sat, Jun 22, 2013 at 1:13 AM, Hilary Lomotey wrote:
> Hello Experts,
>
> In the attached sheet, i have a list of dates in col A and index number in
> Col B. What i am trying to achieve is that in Sheet two, i have written a
> formula to give me index number as at
Hi
To run this macro, just make sure that you replace *Name_of_Macro* with the
name of the macro inside of your Excel workbook that you want to run. Also,
replace *09:30:00* with the time that you want your macro to run.
Private Sub Workbook_Open()
'Runs a macro at 9:30 AM
Application.OnTime Time
Superb!!
I assume you need to increment target by 5 too, coz u r copying 5 rows.
Thanks
On Fri, Jun 21, 2013 at 4:38 PM, Seba wrote:
> Hi,
>
> thank you for your help.
>
> This is the final version of my code:
>
> Sub copy_transpose_chunks()
>
> Dim count, target, coordS, coordF As Integer
>
hey
FYI
http://fracta.net/fracta/index.php/forum/2-excel-vba-forum/15-excel-vba-macro-to-automate-avaya-cms-supervisor-reports
Thanks
On Fri, Jun 21, 2013 at 4:13 PM, Arundatti M wrote:
> Hi Team,
>
> I need help in extracting report from CMS Avaya CRM application to excel.
> If there is any
Welcome on the Borad!!
On Thu, Jun 20, 2013 at 4:16 PM, Muralidharan Thangavelu <
muralika...@gmail.com> wrote:
> --
> Regards,
>
> T.Muralidharan,
> Asst Manager (Electrical),
> L&T ECC Division,
> Krishnagiri Walajabad Road Project,
> Bargur,
> Krishnagiri Dist,
> Tamilnadu.
> Phone-9489202217
Hi
PFA, there are other solution for this.
HTH
On Thu, Jun 20, 2013 at 11:53 AM, Ali wrote:
> Hi all,
>
> I have a worksheet that need to allocate the number of nights spent by a
> guest in the relevant Columns designed for the purpose. I can't seem to
> find the right formula to do this.
>
>
Hi
Highlighted means cells filled with specific color or selected cells.
Thanks
On Wed, Jun 19, 2013 at 5:58 PM, rajan verma wrote:
>
> can anyone suggest a faster way to know which cells are highlighted in a
> Range ?
>
> suppose i have data of 1 lac cell and i have some cells highlighted ,
Hi,
Use this code..
Sub Select_Row()
Range(ActiveCell.Rows, ActiveCell.Offset(4, 0)).EntireRow.Select
End Sub
This will select 5 rows from active cell.
Thanks
On Wed, Jun 19, 2013 at 12:48 PM, Seba wrote:
> Hi,
>
> can someone please advise how to parse a column in excel, so that every 5
>
Hi
Sub MyFooter()
Dim StrFtr As String, Rng As Range, Sh As Worksheet, c As Range
Set Sh = Worksheets("Sheet1")
Set Rng = Sh.Range("A51:G51")
For Each c In Rng
StrFtr = StrFtr & c & " "
Next c
ActiveSheet.PageSetup.LeftFooter = StrFtr
End Sub
HTH
On Mon, Jun 17, 2013 at 4:26 PM, Ira wrote:
> Dim rng As Range
> Set rng = Range("E" & Cells(Rows.Count, "E").End(xlUp).Offset(1, 0).Row)
> cancel = True
> With Selection
> Selection.Copy Destination:=rng
> End With
> End Sub
>
> Regards,
> Sam Mathai Chacko
>
>
> On Sun, Jun 16, 2013
Hi priti
This will keep on overriding existing data one on anothet on click.
We have to change taeget once data is copied in to.
Feedback appreciated.
Thanks
On 16 Jun 2013 16:56, "priti verma" wrote:
> Hi sajid you can also try this
>
> Private Sub Worksheet_BeforeDoubleClick(ByVal Target As
Hi
Try this code:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, _
cancel As Boolean)
Dim rng As Range
Set rng = Range("E" & Cells(Rows.Count, "E").End(xlUp).Offset(1, 0).Row)
cancel = True
With Selection
Selection.Copy Destination:=rng
End With
End Sub
Here rng specifies destina
Hi,
You may refer:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=475
http://www.vbaexpress.com/kb/getarticle.php?kb_id=540
File with example is there for better understanding..
Best Luck
On Sun, Jun 16, 2013 at 12:03 AM, sunil lobo wrote:
> hi all
> can anybody suggest a vb code or a m
PFA
http://www.xl-central.com/list-files-dir.html
http://www.excelvbamacros.com/p/index_1.html
Thanks
On Sat, Jun 15, 2013 at 5:39 PM, Vijayendra Rao wrote:
> Dear All,
>
> Is there any macros to create list names with subfolder and propertis from
> any folder. Currently I am using ASAP-Utili
in vba function split function is working is magic of instr:
Instr checks each word in sentence, if it contains @ then it is picked up &
thrown as result..
its using right logic with right function to reach destination in fastest
way..
HTH
On Sat, Jun 15, 2013 at 3:21 PM, ravinder negi wrote:
refer..
On Fri, Jun 14, 2013 at 12:10 PM, Pravin Gunjal wrote:
> Hi,
>
> I want to convert the date =Today() to this format : DD.MM.
>
> Formula =Today() 6/14/2013 In next cell, it should display as :
> 14.06.2013
> Sample file is attached. Thanks.
>
> Regards
> Pravin Gunnjal
>
> --
>
Hi JK,
Desired result can be achieved using PVT table, you need to add one column
& mention string in to the same.
Now make pvt & refresh the same once data is added.
Pl refer att.
HTH/Thanks
On Thu, Jun 13, 2013 at 2:53 AM, jk9045 wrote:
> Hello everyone,
>
> I have an excel sheet that has
Hi
Try this, hope it will help:
https://docs.google.com/open?id=0B7i2wkMBVw9xQV9tb3hhZVdXWFE
Thanks
On Wed, Jun 12, 2013 at 9:25 AM, Prabhakar S H wrote:
> Dear Team,
>
> MY HR given me responsibility to give training on Excel to my Marketing
> team. So can you send me the materilals on Basic
This can be done using Mail Merge in word only.
Refer link here:
http://www.timeatlas.com/5_minute_tips/chunkers/mail_merge_tutorial_using_microsoft_word_and_excel#.Ubcqfvn7AqI
Thanks
On Tue, Jun 11, 2013 at 7:15 PM, VBA VABZ wrote:
> Hi,
>
> Why you need output in word?
>
>
Hi,
Why you need output in word?
On Tue, Jun 11, 2013 at 7:09 PM, Atul Kesaria wrote:
> Hello Expert,
>
> I need a help in creating a macro which will pick data from excel sheet to
> mail merge to a predefined Word template.Attached is a sample word & Excel
> Format.
>
> Request your expert op
thanks for sharing!!
On Mon, Jun 10, 2013 at 1:32 PM, P.VIJAYKUMAR wrote:
> Respected Mr Excel,
>
> You can check the following links.
> http://allenbrowne.com/tips.html
> http://www.baycongroup.com/access2007/
> http://www.gcflearnfree.org/access2007
> http://ms-access-tips.blogspot.in/p/advan
Hi
Send sample file for more clarity
Thanks
On Tue, Jun 4, 2013 at 9:51 AM, wrote:
> Dear expert,
> Many time I have to add every third or every forth or every second row or
> column etc...can you suggest a function which will ease my problem! Till
> now I am adding required cell one by one
Thanks!!
On Mon, Jun 3, 2013 at 7:42 PM, Ashish Kumar wrote:
> Dear Frndz,
>
>
> Use full link to learn Excel. please find attached link!!!
>
>
>
>
> http://www.excel-pratique.com/en/index.php
>
> Thanks
> Ashish
>
> --
> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I
Shire Council in Thargomindah Queensland Australia.
>>
>> Regards
>> David Grugeon
>>
>>
>>
>> On 27 May 2013 16:13, VBA VABZ wrote:
>>
>>> hey
>>>
>>> for which co you work.
>>>
>>> thx
>&g
Hi
Either source sheet has filter or merged cells. Try clearing out filter
and perform operation again.
If doesn't work send us sheet.
HTH
On 28 May 2013 10:07, "Prabhu Pinky" wrote:
> hi experts
>
> I have one excel, from that excel I am unable to copy and paste the data
> to new excel..even
hey
for which co you work.
thx
On Mon, May 27, 2013 at 7:20 AM, Bv Dileep wrote:
> Hello,
>
> ** **
>
> Please find attached the sheet.
>
> ** **
>
> Macro Requirement : I will receive the data for 20 associates in my team
> in a separate sheets (20 Sheets) in the attached format. Now
hi
if data is in date format then, use =text(cellref,"mm")
Thanks
On Fri, Apr 19, 2013 at 6:14 PM, colmkav wrote:
> Hi,
>
> what excel formula do I need to convert a date field into the month number
> like 03 for March?
>
> for example cell A3= #31/03/2013#
>
> I want "03" in my new cell.
>
>
hi
Since you restricting to specific sheet it doesnt work..
Try dis:
Public g_blnUpdate As Boolean
Public Sub Protect_Unprotect()
'With ThisWorkbook.Worksheets("Sheet1")
targetws = ActiveSheet.Name
With ThisWorkbook.Worksheets(targetws)
If g_blnUpdate = True Then
g_blnUpda
hi
can u send me sample data...
Rgds
On Tue, Nov 6, 2012 at 10:24 PM, veerendra vanam
wrote:
>
>
> On Tue, Nov 6, 2012 at 3:44 PM, veerendra vanam > wrote:
>
>>
>> Dear all,
>>
>> i am sending mail particular updated file summary sheet as
>> body, every 1hr like 01:00hr,02:00hr,03:00hr,
Hi
Nice work, you can automate it through conditional formating.
Rgds//Vabs
On Wed, Oct 24, 2012 at 12:49 PM, Yahya Muhammad wrote:
> Hi experts
>
> I want to compile the annual leave schedule of each staff in the
> department in excel. The idea is to have all the schedule in one work
> sheet,
Hi
It could not be so.
Check whether you have provided correct sheet name in your project sheet
also..
Rgds//Vabs
On Wed, Oct 24, 2012 at 4:05 PM, Kenil Gala wrote:
> Hi all,
> Pls help me solve my query.
> I have written my query in the attachment .
>
> Thanks & Regards.
>
> --
> Join offici
hi
Really nice..
Rgds
On Tue, Sep 25, 2012 at 10:41 AM, Amit Desai (MERU) wrote:
> To all my dear friends,
>
> ** **
>
> Nice Excel filewith ABCD on Friendship...
>
> Please see the attachment and click on flowers.
>
> Best Regards,
>
> Amit
>
> ---
Hi..
I mean u can do this on any excel file..
Rgds
On Sat, Sep 22, 2012 at 2:55 PM, Rajan_Verma wrote:
> *File??*
>
> * *
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behal
Pl check & confirm is it working now..
Rgds
On Wed, Sep 19, 2012 at 11:41 PM, B.N.Chethan Kumar <
chetankumar1...@gmail.com> wrote:
> check..if these help. check and let me know
>
> Regards
> CK
>
> On Wed, Sep 19, 2012 at 2:45 PM, SG wrote:
>
>> Experts,
>>
>> plz help mei need solution.pl
Hii
I didnt see ur emailproperly,
See is this what you are looking or may be you can change the code the way
you want.
You can modify string in blue to get desired result..
Cheers..
Rgds//Vabs
On Wed, Sep 19, 2012 at 4:52 PM, VBA VABZ wrote:
> Pl share sample sheet with data &
of cell I1
>
> ' Earlier F now should be value of cell I2
>
> If Cells(r, *"cells(1,"I")"*) = "Single" Then
>
> Cells(r, *"cells(2,"I")"*) = "8000"
>
> Else
>
> If Cells(r, *"cel
VBA VABZ has invited you to sign up for Google Talk so you can talk to each
other for free over your computers.
To sign-up, go to:
http://www.google.com/accounts/NewAccount?service=talk&sendvemail=true&skipvp
hi
=IF($B$3:$B$22=$M4,SUMPRODUCT(--($H$3:$K$12=1)),SUMPRODUCT(-
-($H$13:$K$22=1)))
For each cell in range in B3 to B22 if it is equals to m4 then ...
If True: here for each cell in range H3 to K12 if cell is equal to 1 then
give sum of all cells which is equal to 1..
If False: here for each cel
hi
PFA
Check this i have added new column in Pvt Table..
After updating value right click Pvt Tble & select refresh button if you
are not doing same to update value..
Cheerz..
Rgds//Vabs
On Wed, Sep 19, 2012 at 2:45 PM, SG wrote:
> Experts,
>
> plz help mei need solution.plz look in to
;
>> * *
>>
>> * *
>>
>> *Regards*
>>
>> *Rajan verma*
>>
>> *+91 7838100659 [IM-Gtalk]*
>>
>> * *
>>
>> *From:* excel-...@googlegroups.com [mailto:excel-...@**googlegroups.com]
>> *On Behalf Of *VBA VABZ
>&g
Dear Jorge
HI
U can try this..
=TRIM(RIGHT(SUBSTITUTE(LEFT(A4,FIND(" ",A4&" ",FIND("<>",A4))-1)," ",REPT("
",99)),99))
If doesn't work share sample data.
Cheers..
Regards//Vabs
On Mon, Sep 17, 2012 at 8:49 PM, Jorge Marques wrote:
> Hi, I´m sorry to be writing in this post, but I don´t thi
58 matches
Mail list logo
