I have alread tried that.
I have put date range as 1-Jun-2010 to 21-Jun-2011.
On Wed, Jun 22, 2011 at 9:17 PM, ashish koul wrote:
> chage the date in cell d2 and f2
>
> and client in b2 and then run the macro
>
>
> On Wed, Jun 22, 2011 at 7:35 PM, sharad jain wrote:
>
>> Thanks Ashish,
>>
>> B
A macro used to delete empty rows and assign some values on multiple
worksheets is, for some reason, also deleting all drawing objects (e.g.,
textboxes, lines, etc.) in the workbook. The problem only occurs on one PC
(the user just got 2007 installed). (When she was using 2003 the macro
worked
Dear Group,
Only 2 days left.
On Tuesday, 21 June 2011 23:35:38 UTC+5:30, Ayush wrote:
> Dear members,
>
> Hope you are doing great !
>
> This is very exciting news !
>
> John Franco has just opened enrollment for his premium online private
> coaching program "Dynamic Lookup Secrets"
>
>
going forward post your query on the group
Sub test()
Dim i As Long
For i = Sheets(1).Range("a65356").End(xlUp).Row To 2 Step -1
Sheets(1).Select
If Sheets(1).Cells(i, 4).Value = 0 Then
Sheets(1).Cells(i, 4).EntireRow.Delete
End If
If Now() - CDate(Sheets(1).Cells(i, 3).Value) > 90 Then
Row
try this
http://peltiertech.com/Excel/Charts/
On Wed, Jun 22, 2011 at 7:56 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Pleaase can I get 2007 code to get good looking chart as 2003. Thanks!
>
> On Wed, Jun 22, 2011 at 2:04 PM, ashish koul wrote:
>
>> Sub check()
>> If Applica
chage the date in cell d2 and f2
and client in b2 and then run the macro
On Wed, Jun 22, 2011 at 7:35 PM, sharad jain wrote:
> Thanks Ashish,
>
> But the file only gets the data from 10-Jun-2010 to 19-Oct-2010.
>
> Also can you please let me know how create this type of macro?
>
> Thanks,
> S
pls try this
Sub locksheet()
Dim DataRng As Range, DataFilledRange As Range
Dim WkSht As Worksheet
Set DataRng = ThisWorkbook.Worksheets("April").Range("C3:F7")
Set WkSht = ThisWorkbook.Worksheets("April")
WkSht.Unprotect
With WkSht.Cells
.Locked = fase
.FormulaHidden = False
End With
For Each
Pleaase can I get 2007 code to get good looking chart as 2003. Thanks!
On Wed, Jun 22, 2011 at 2:04 PM, ashish koul wrote:
> Sub check()
> If Application.Version = "12.0" Then
>
>
> ' code for 2007
>End If
>If Application.Version = "11.0" Then
>'code for 2003
>
>
Thanks Ashish,
But the file only gets the data from 10-Jun-2010 to 19-Oct-2010.
Also can you please let me know how create this type of macro?
Thanks,
Sharad
On Wed, Jun 22, 2011 at 7:18 PM, ashish koul wrote:
> try this
>
>
> On Wed, Jun 22, 2011 at 5:59 PM, Ketan wrote:
>
>> Dear Members,
Thank u very much :)
On Wed, Jun 22, 2011 at 1:36 PM, ashish koul wrote:
>
> http://www.bonavistasystems.com/Download2/MicroChartsTutorialBulletGraph.pdf
>
> http://www.exceluser.com/explore/bullet.htm
>
> http://www.anychart.com/products/anychart/docs/users-guide/Bubble-Chart.html
>
> http://pe
Hi Vasant
Thanks for the code, its working well I need a condition in this the
columns must not be locked in case all the data entry cells filled eg;
A B C D E F G H I
S N NAME1 2 3 4 5 6 7
3
try this
On Wed, Jun 22, 2011 at 5:59 PM, Ketan wrote:
> Dear Members,
>
> ** **
>
> I have attached file which has macro to fetch data from NSE website
>
> ** **
>
> In that I want that query to be customized like date range to change and
> company name also changed
>
> So that I
pls try this
this will lock the populated cells in the range C3:AA5 in sheet 'april'
Sub locksheet()
Dim DataRng As Range, DataFilledRange As Range
Dim WkSht As Worksheet
Set DataRng = ThisWorkbook.Worksheets("April").Range("C3:AA5")
Set WkSht = ThisWorkbook.Worksheets("April")
WkSht.Unprotect
Fo
Hi Ashish,
Thank you so much for the awesome help. I really appreciate it! The
workbook works fantastic!!!
I have a few questions
1,
Is it possible to use the values in D1: F1 (H3351, H3335, S3521) as
the series names when creating the chart? How to do so in the macro?
2
When I click the dark b
No, this is daily entry sheet for fuel issued to equipments. This will
continue for years.
Regards,
Subhash Yadav
On Wed, Jun 22, 2011 at 6:16 AM, ashish koul wrote:
> @ICWAI Help - subhash has already attached the file. please check the
> mail trail
>
> @subash - is there any fixed range
hi all,
I want to learn VSTO for excel.anybody please give me the notes,pdf or
urls for learning.
thanks & regards...
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Hi Experts
I add a code in the work sheet for the identification of data
selected, But the copy paste is not working in that sheet. How can I
solve the issue,Pls check the code & tell me the change required.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.EnableEvents = F
Sub check()
If Application.Version = "12.0" Then
' code for 2007
End If
If Application.Version = "11.0" Then
'code for 2003
End If
End Sub
On Wed, Jun 22, 2011 at 11:15 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> Can we write diff
http://www.bonavistasystems.com/Download2/MicroChartsTutorialBulletGraph.pdf
http://www.exceluser.com/explore/bullet.htm
http://www.anychart.com/products/anychart/docs/users-guide/Bubble-Chart.html
http://peltiertech.com/Excel/Charts/
On Wed, Jun 22, 2011 at 11:20 AM, Chandra Shekar <
chandras
http://www.anychart.com/products/anychart/docs/users-guide/Bubble-Chart.html
http://peltiertech.com/Excel/Charts/
On Wed, Jun 22, 2011 at 11:20 AM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hi,
>
> I would like to learn about Bullet chart and Indicator chart(Gauge Chart).
> Please
Hi,
I would like to learn about Bullet chart and Indicator chart(Gauge Chart).
Please let me know which would be the best site to get required information.
I tried in Chandoo.org(Indicator Chart) but If I use his instruction I am
not getting correct output.
Thanks,
Chandra Shekar B
--
Hi,
Can we write different code do this. Where VBA code knows which version user
is using according to that it changes chart plot area. If yes please let me
know. Thanks!
On Wed, Jun 22, 2011 at 12:34 AM, Daniel wrote:
> Charts are quite different with Excel2007, so you have to resize the plot
Hi Ashish,
Thanks for the reply. Still user can edit and change text or assign a new
macro the textbox, but I want user not to edit text box and assign new macro
to it. Just he need to click on that to generate reports. Thanks!
On Tue, Jun 21, 2011 at 9:20 PM, ashish koul wrote:
> Try this
> ri
23 matches
Mail list logo
