A most excellent solution..
Ken
On Oct 23, 5:44 pm, anandydr wrote:
> Hi,
>
> One simple method would be to incase your formula in and IF formula
> which can put NA( ) instead of zero. e.g.
> =IF(COUNTIF(A1:A100,"T")=0,NA( ), COUNTIF(A1:A100,"T"))
I have two columns of numbers. Column A is sequential dates. Column
B is data gathered from time to time and entered in the appropriate
date row as related to Column A. Column B has lots of blank rows
without data. Reason: I do not gather data each day. All the rows
below the last entry in Co
I have a sheet where I am listing the data (numbers) in columns. I add
data at the bottom of the columns as I get it. I plot a single column
of data using the offset function within a Named range to set the data
to plot against the number of data points input; plus a few blank rows
(e.g. 30) below
r.ColorIndex = 6 Then
ActiveCell.Interior.ColorIndex = xlColorIndexNone
Else
ActiveCell.Interior.ColorIndex = 6
End If
End If
Next Cell
ActiveCell.Offset(1, 0).Select
End Sub
=======
The Double Click Macro i
lay
$H$2 = Number of days to average. A variable I can change.
Ken
On Sep 29, 5:52 am, "dguillett1" wrote:
> Send your file with a complete explanation and before/after examples to
> dguille...@gmail.com
>
>
>
> -Original Message-
> From: Ken
> Sent:
I have a spreadsheet where I track my Poker play. I play a few times
per week. The amount of play varies a lot. Each time I play I add a
row to a sheet with the date, hrs played, loss, win, etc and computer
various values; cash flow, win / loss ratio, best day of week to play,
best game, etc. e.
I have the file stored on Google Docs at:
https://docs.google.com/leaf?id=0B2wwdgJj4ncpYzQ0MTFiNzQtNDAxMi00NGNmLWIzMjMtYmM0NjQyNTY3Y2Nm&hl=en&authkey=CLjt6zY
On Feb 23, 4:01 pm, Ken Hansen wrote:
> Hi all,
>
> I have a Sales Tracking workbook. I have 2 issues that I can&#x
ssion
Worksheet.
It currently allows manual input in the commission cells, then you can
refresh and it's all OK. I am trying to make it goof-proof, so any
sales rep can enter from a form and accurately track performance.
I will upload this to files as saleslog.xlsm
Thanks in ad
Alternatively, you can reference the Microsoft Internet Controls library
from the VBA IDE and use the methods and props of ShDocVw.InternetExplorer
application object to navigate around.
-Ken
On Mon, Dec 6, 2010 at 1:01 AM, kanwaljit Singh wrote:
> Thanks,
>
> I am trying to fill in
Try this
Sheet1.Columns(2).Specialcells(xlBlanks).Delete
On Sun, Dec 5, 2010 at 6:36 PM, robert peloquin wrote:
> Sorry for the multiple post, trying to send an attachment, not sure how to
> go about this.
> I have a strange sort question. In column B there is information
> every
> 7 rows.
This is most important question to ask: What are you trying to do with IE
from Excel?
-Ken
On Sun, Dec 5, 2010 at 3:28 PM, kanwal_no1 wrote:
> Hi All,
>
> I am using the following portion of a code to open the Internet
> Explorer from Excel
>
> Sub OpenIE()
> Dim IE As
OUT
Application.CutCopyMode = False
Sheets("DAILYOUT").Select
Range("A2").End(xlDown).Select
ActiveCell.Offset(1, 0).Select
With Application
.ScreenUpdating = True
.EnableEvents = True
End With
Application.Run "Reset"
Exit
OUT
Application.CutCopyMode = False
Sheets("DAILYOUT").Select
Range("A2").End(xlDown).Select
ActiveCell.Offset(1, 0).Select
With Application
.ScreenUpdating = True
.EnableEvents = True
End With
Application.Run "Reset"
Exit
Val nShowCmd As Long) As Long
Sub SendEMail()
Dim Email As String, Subj As String
Dim Msg As String, URL As String
Dim r As Integer, x As Double
For r = 2 To 8208
Thanks for the group!
Ken
> On Mon, Jan 5, 2009 at 5:42 PM, girishkr...@gmail.com
> wrote:
>
> This
14 matches
Mail list logo
