I am new to VBA although not new to VB, nevertheless I have found VBA to
be an absolute nightmare.
I am trying to acheive something very simple that should be a very basic
task in a spreadsheet macro language:
varable1 = cell(row,col)
cell(row,col) = modified_variable1
I have found the Excel manuals next to useless, and the on-line help
gives me volumes of information but not what I need to know.
I have tried things like:
variable1 = worksheets("Sheetname").cells(row,col).value
variable1$ = worksheets("Sheetname").cells(row,col).text
variable1 = worksheet(Sheetnumber).cells(row,col).value
variable1 = cells(row,col).value
and many other variations on the same theme including things like
activesheet instead of worksheet etc. Nothing seems to work. I just keep
getting null values back or syntax errors.
Can anyone help?
I have also seen other letters in this newsgroup about a similar problems
so I see that I am not the only one. To be able to acheive the above
is surely a very basic function for a macro language associated with a
spreadsheet and should not be so difficult to find a solution to. But
then it IS made by Microsoft....
So what is Microsoft playing at? If they are serious about making this an
office application development language then perhaps they should do
something about simplifying it and providing some decent manuals.
##===(__ __)<==/ ___)<============= Network Technician <=======##
|| | | | | School of the Built Environment ||
|| _| |ohn | |___hajecki De Montfort University ||