I tried to attach a sample workbook but it got rejected for some reason. I
added the following code to the "This Workbook" section of the VBA project:
Private Sub Workbook_Open()
Dim dteNow As Date, iLoop As Integer, strMessage As String
dteNow = Date
For iLoop = 1 To Works
Hi Nicola (NWT)
The code is working fine on my system. But we use . (dot,period,full
stop) as decimal separator instead of , (comma) for decimal/double/
real numbers.
I don't know about italian system but think programming practices are
followed same throughout the world. So kindly replace , with
Dear all,
I have a worksheet data (sheet1)
Sheet1
---
Name direction CC DD
n1 left 1 2
n1 left 3 4
n1 right5 6
n1 right7 8
n1 right9 10
n2 left11 12
n2 left13
Hi all,
i'm trying to insert a formula by vba, the code looks like this:
dbl_weight = 27,7
activecell.FormulaR1C1 = "=RC[-6]*" & dbl_weight
runtime error 1004
if my dbl_weight = 27 it works
my excel 2003 is in italian
any suggestion?
Thanks,
Nwt
--~--~-~--~~~---~
Hi All,
I want to put some reminders in my excel sheet which we open regularly.
Suppose a pop up message box appear on a particular date stating" Hello
today is the birthday of your team memeber" or " need to send a mail to some
one".
Regards
Santosh
--~--~-~--~~~---~
If you're a lotto player, you likely know some sites where you can go
and enter your chosen numbers to check against the actual winning
numbers that played the night before.
I want to turn the tables, since I have about 10 sets of numbers (10
tickets, but most of the time it's 5 sets I play).
