Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA Syntax Question?
I want to code a module below using datasheet and querysheet but not good in vba code. Look in the datasheet at row2 for a value of 1, if found, then look at next row i.e. row3 for value found in the querysheet e.g. in this case are 1,3,5,6,9 . If found, it will write the date & rowno of row2 of datasheet and the value of 1 & 0 will be insert accordingly to the column in the querysheet. This macro will run the loops from row2 of datasheet until the last row. New found items/values will be written row after row in the querysheet. Can anyone help. Some questions concerning VBA syntax. Q1) To use a workbook/worksheet Q2) Do whil not eof() & Enddo. Q3) Checking a range of cells for value Q4) Skipping next row Q5) Writing value to particular cell. Q6) Do Case & Endcase. Please kindly show me what are these syntax in VBA. Thank you for helping. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct syntax question | Excel Worksheet Functions | |||
Syntax question | Excel Worksheet Functions | |||
VBA syntax question | Excel Discussion (Misc queries) | |||
syntax question | Excel Worksheet Functions | |||
BringToFront syntax question | Charts and Charting in Excel |