Dear all experts
i am using a sheet where a cell containg a formula
cell:{=SUMPRODUCT(IF(($G9:$AS9<=BV$3)*($G9:$AS9>0),1,0),$G$4:$AS$4)}
where if i duble click or delete this sign {} the out come is
cell:#VALUE!
shatanu
please help me out
--
-
Dear Group
I have created one macro, I want to use this macro as add ins, how can I use
this pls help
regards
Dharmesh Shah
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and li
Hello Team,
I need a macro code to add a row based on certain value in particular
row. So for eg if A1=50 then add a row below A1 and copy the above
data in the added row, a2=100 then no need to add row move on to next
row ...if a3=50 then add row below that and so on till the last row.
Thanks an
Hi Renuka,
Try using following formula.
=TEXT(DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)),"mm/dd/")&"
"&TEXT(TIME(HOUR(A1),MINUTE(A1),SECOND(A1)),"hh:mm am/pm")
Let me know if this solves your problem :)
Best Regards,
DILIPandey
On 10/11/10, renuka chari wrote:
> hi excel experts i have a small p
Hi Siti Vi
*Superbly codedThat was excellent..full praise you*
Thanks for excellent reply
Regards
L SUDHEER
On Tue, Oct 12, 2010 at 7:02 AM, siti Vi wrote:
> Hi Lolla,
> check this code
>
> - the VBA code -
> Dim *DelValue*
>
> Private Sub Works
Dear Manoj,
I am sure that I have answered both of your queries in the past. You
are requested to browse / search the Group's discussion section:-
http://groups.google.com/group/excel-macros/
Regarding query related to reminder, Yes, I have solved this one as
well but not sure if marked to the g
Dear Rakasekhar.
I am not able to understand your problem actually... :(
How you are assigning the names against tasks ?
I believe creating a pivot table and then using "Show Pages" option
you can assign the tasks to different individuals.
Please explain further if you need some other solution.
Hi all.
I have a X-coordinate and some Y-coordinate and want to make a chart
(with macro).
X
-5
-4
-3
-2
-1
0
1
2
3
4
5
Y2
-5,307692308
-4,076923077
-2,846153846
-1,615384615
-0,384615385
0,846153846
2,076923077
3,307692308
4,538461538
5,769230769
7
Y1
-4,2
-2,6
-1
0,6
2,2
3,8
5,4
7
8,6
10,2
hi Dilip,
firstly i will be copying the pivot table from task distribution sheet.
Row Labels Sum of # of no hits DEEPTI 45 LAKSHMI 35 NIKHIL 46 PUSHPA
15 RAVI 7 SAI 35 VENKAT 46 ARVIND 21 Grand Total 250
this part from task distribution sheet and click on extension bar (+) to get
th
Not sure how well this copied but I have gl accts on the left with the
months across the top. I need to copy only the acct data over to
another tab and occasionally new accounts will be inserted so I don't
want to "lock" in the range. I would like to go to Dec Actual for
acct 60, shift end do
Hi Friends,
Happy Navratri all of you,
Can any body tell me about webquery, I knw how to use web query but i
want to more information about webquery, how to access data from
website to enter date and download in excel, please refer below link
http://www.sebi.gov.in/MFTrends.jsp
In Box automatic
Hi,
wondering if someone can help. I'll try to be as specific as I can.
I want to have a formula that will change according to the Category
word I select from the drop down selection function. Otherwise I have
to copy and paste the formula I have now and manually enter in each
different category
I have these three subs in the ThisWorkbook code block:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
MsgBox ("BeforeSave")
End Sub
Private Sub Workbook_Save(ByVal SaveUI As Boolean, Cancel As Boolean)
Call Workbook_SaveAs(SaveUI, Cancel)
End Sub
Private S
Dear,
I have many excel files which were included their macro (VBA code).
Now I want to write a script (VBA) to open them and run their macro
automatically.
Could you have any suggestion to me for solve this?
Thank a lot!
Muon
--
--
Your formula is an ARRAY FORMULA
To enter the Array Formula you have to press *[Ctrl] , [Shift] + [Enter]
button
*(not only just [Enter]
learn more : http://www.cpearson.com/excel/ArrayFormulas.aspx
On Tue, Oct 12, 2010 at 1:59 PM, shantanu chouhan <
chouhanshanta...@gmail.com> wrote:
> Dear a
Dear All,
I want my macro to be executed only for specific day in a month based on
system date and it should not run thereafter.
Kindly let me know the code for it.It's urgent.
Regards,
C.G.Kumar
--
--
Some i
only work on day 5 to 10 of the month
sub blablabla()
if day(date) >= 5 and day(date) <=10 then
* *your full macro*
*
end if
end sub
On Wed, Oct 13, 2010 at 12:26 PM, C.G.Kumar
wrote:
> Dear All,
> I want my macro to be executed only for specific day in a month based on
system date and
17 matches
Mail list logo