ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   question about the macro vb some one help? (https://www.excelbanter.com/excel-programming/305472-question-about-macro-vbulletin-some-one-help.html)

nader

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


JulieD

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/




nader

question about the macro vb some one help?
 
thankyou mr julied for your hel

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


JulieD

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/





All times are GMT +1. The time now is 05:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com