vba command

P

paul

can anyone help me write vba commands for these below

amy help would be grateful

a/ Place in the variable Y the number in the cell A6 of the currently
active worksheet (4 marks)

b/ Place in the cell A7 the text "Hello world"
c/ Place a message box on the screen giving the message contained in
the string variable, Prompt$ and asking for a yes, no or cancel reply

d/ Read the area designated by the string variable Area$ into a one
dimensional array called Input()
e/ Read the 5th column and 3rd row of the currently active spreadsheet
into the array element A(2,4)

f/ Read the value in the cell B7 from worksheet, sheet6 into the
variable, Step
 
G

Guest

I can help answer homework problem b

paul said:
can anyone help me write vba commands for these below

amy help would be grateful

a/ Place in the variable Y the number in the cell A6 of the currently
active worksheet (4 marks)

b/ Place in the cell A7 the text "Hello world"
Click to expand...
Range(Cells(1, 7), Cells(1, 7)) = Chr(72) + Chr(101) + Chr(108) + Chr(108) +
Chr(111) + Chr(32) + Chr(87) + Chr(111) + Chr(114) + Chr(108) + Chr(100)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vba tips and help 5
vba array logic 3
Find Command 9
Array - delete and replace elements 2
How to access VBA variable from active worksheet 1
Data exchange between macro and spreadsheet 1
How to execute a command in VBA 2
how to assign contents of a cell to a macro variable 3

Top