Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Visual Basic displaying....

Status
Not open for further replies.
swiff

swiff

Technical User
Apr 28, 2001
2
AU
Hi there,

As a novice...

How do I display a value into an Excel Cell??

Is this right?

for example:

Sheet1.Range("B" & n) = n

Cause it doesn't work...

any ideas...

thanks a lot

Jacintha
 
Sort by date Sort by votes
Like this:
Sheet1.Range.("A1").Value = 1

OR

Coord = "A1"
Sheet1.Range.(Coord).Value = 1
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

marty1944
  • Locked
  • Question
error code 380 when trying to run the visual basic v6 deployment wizard
Replies
1
Views
813
marty1944
marty1944
VisKataboman
  • Locked
  • Question
Linear Column Gauge measurement form on Visual Basic 6.0
Replies
1
Views
410
xwb
xwb
2009luca
  • Locked
  • Question
DISPLAYING pdf in picturebox
Replies
9
Views
863
sal21
sal21
NewAccount13
  • Locked
  • Question
How to use Split function with Unicode Delimiter in Visual Basic 6
Replies
6
Views
599
strongm
strongm
MAVTCR
  • Locked
  • Question
Visual Basic 2017
Replies
1
Views
204
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top