Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
I have written a series of macros which insert rows in a database. Each macro inserts one line with data from the spreadsheet. I want to avoid sending null rows to the database, but I need to allow for up to 20 rows to be transferred to the database at a time, when there may be any number between 1 and 20 to be updated weekly. Does anyone know of a way to do this? This is the first time I have used VBA, I have some knowledge of java. Is there an 'if' statement that can be used in VBA? Thanks for any help. :) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Null values need to be replaced | Excel Discussion (Misc queries) | |||
sum if - null values | Excel Discussion (Misc queries) | |||
VLookup Null values | Excel Worksheet Functions | |||
selectin all the values in a column including null values | Excel Programming | |||
return a " " for null values | Excel Worksheet Functions |