View Single Post
  #29   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default Issue with blanks and spaces

On Thursday, March 20, 2014 11:18:42 AM UTC-7, Claus Busch wrote:
Hi Howard,



Am Thu, 20 Mar 2014 11:00:00 -0700 (PDT) schrieb L. Howard:



The sheets of concern at this time are Publish Data, Title Builder and Description Builder.


Title code needs to fill column A of Title sheet and column B of Publish.


Description code needs to fill column A of Description sheet and column E of publish.


Mostly it is doing that but the list seem to be correctly done but not identical.


That is: the list on Titles column A and the list on Publish column B are different from one another after each running of the code.


The same for Description.


Also need to be able to run Titles and Description code from Publish sheet. There is a button for each. This seems to somewhat of a problem.


I'll be dealing with the other sheets to do similar work, but hopefully I can use the correctly done code for Titles and Descriptions to guide me.




at the moment I am a little bit confused.



Should the list in column A or Title and column B of Publish be the

same?

Also for Description and Publish?

Or should be randomized between running the code?





Regards

Claus B.


Each time the code is run for Titles both destinations should be identical lists.

Titles column A on Titles sheet and column B on Publish sheet.

Descriptions column A on Descriptions sheet and column E on Publish sheet.

Howard