Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default question about the macro vb some one help?

I use the mecro to print data in the cells of excel
so I put this code : cells .cells=8 for that, it print the number(5)
in all of the cells
I want to print in specify cells like : a1, b2 ..etc
how caN I DO that.
and thankyou for hel

--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 618
Default question about the macro vb some one help?

Hi
try something along the lines of

Range("A1,B1,C1").Value = 5
or
Range("A1:C1").value = 5

Cheers
JulieD

"nader " wrote in message
...
I use the mecro to print data in the cells of excel
so I put this code : cells .cells=8 for that, it print the number(5)
in all of the cells
I want to print in specify cells like : a1, b2 ..etc
how caN I DO that.
and thankyou for help


---
Message posted from http://www.ExcelForum.com/



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default question about the macro vb some one help?

thankyou mr julied for your hel

--
Message posted from http://www.ExcelForum.com

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 618
Default question about the macro vb some one help?

Hi

you're welcome - but do make that mrs julied :)

Cheers
JulieD

"nader " wrote in message
...
thankyou mr julied for your help


---
Message posted from http://www.ExcelForum.com/



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Macro/VB Question DDE Question MadDog22 Excel Worksheet Functions 1 March 10th 10 01:47 AM
Macro Question Carl Excel Worksheet Functions 1 August 25th 06 07:40 PM
Macro Question carl Excel Worksheet Functions 1 August 3rd 05 07:56 PM
Macro Question? Greg B Excel Discussion (Misc queries) 7 March 9th 05 01:08 PM
Macro Question dizzydean Excel Programming 2 December 23rd 03 06:15 PM


All times are GMT +1. The time now is 06:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"