Jobberman
Kishke
Level: 43
   
Posts: 302/423
EXP: 560974
For next: 4077
Since: 2.1.02
From: Ft. Lauderdale, FL
Since last post: 362 days
Last activity: 42 days
|  #1 Posted on 4.5.05 1334.22
Reposted on: 4.5.12 1334.22 | From reading this forum for a few years, I know there are some very intelligent people around here. Hopefully one can help a bit. 
I am trying to put a little piece of code in a visual basic program that will check a specific cell in an MS Excel spreadsheet. If the cell is empty, it will generate a random number and insert it. If the cell already has a value in it, no change would be made. I know very, VERY little as far as programming goes, so searches for this always led me to places way over my head.
Any help would be appreciated,
Thanks. | Promote this thread! |             | whatever
Lap cheong
Level: 78
Posts: 619/1641
EXP: 4265159
For next: 117086
Since: 12.2.02
From: Cleveland, Ohio
Since last post: 2 days
Last activity: 13 hours
| #2 Posted on 4.5.05 1351.31
Reposted on: 4.5.12 1351.51 | This is a sample I used in some VBA code embedded in an Excel spreadsheet.
This line checked if the cell value was blank. You could use the line in an "If-then" setup to set the .value parameter to the random number.
Sheet#.Cells(X, Y).Value = ""
where
# = the sheet number in Excel,
X = row number on the sheet
Y = column number on the sheet
Hope this helps!
| | ALL ORIGINAL POSTS IN THIS THREAD ARE NOW AVAILABLE |
| | |
