Replies

Perhaps you should reconsider the goal – why would anyone want all text in a worksheet to be in upper case? It’s exceedingly ugly, and the time of mainframes that only support text in upper case is 30 years or more behind us…

I should make it clear that it is not my goal but that of a third party. For what it is worth I entirely agree with the sentiments you express about the use of upper case text. But the third party is immune to them.

Thank you for your kind and courteous response.

You should be able to modify the following macro:

Code:

Sub FixFormatting()
  Dim r As Long
  ' Adjust the lower and upper bounds as needed
  For r = 1 To 100 Step 3
	Rows(r).ClearFormats
  Next r
End Sub

Change the values 1 and 100 to what you need.

Hans,

Thank you for your help and rapid response. I was able to suitably modify the routine and use it successfully.

I am grateful indeed,

Malcolm

Not a problem, copy column C and then in the new worksheet select the range and click EDIT—> Paste Special and then select Values

This converts it for you…..

That solves the whole issue for me. Thank you very much for your assistance. The drinks are on me when we meet!

Malcolm

Hi Malcolm

In cell C1 type:

= A1 & ” ” & B1

And copy down using the fill handle to C400 +

Thank you – That’s works fine. But there’s a BUT!

When I copy and paste column C into a new worksheet the first and last names are replaced by #REF! Having achieved the object is it possible to remove the dependence on the formula?

Malcolm,
See attached.
As for the MS Newsletter template, I suspect the newsletter’s multi-column format may have something to do with your problem, since even a floating table’s width can’t span multiple columns.

Thank you for the attachment – it makes sense and your demo proves what you said in your first reply.

The template doesn’t have multi columns – it is mainly text boxes. However near the top of the second page there are two carriage returns behind a text box. Removing these carriage returns results in the loss of the second page itself and its contents being superimposed on the first page content.

My conclusion is that apart from wasting my time and yours the image position is related to the second page rather than the table cell.

At this point I am giving up but only for the time being as I have to print and post my newsletter today. For the next issue I’ll be looking for a `better’ template or I’ll make my own.

Thank you for your interest and contributions.

Malcolm

Malcolm,
You can’t do that with a textbox, but you can probably achieve the desired effect via a single-celled table.

Thank you for your response. Unfortunately although what you say makes sense it hasn’t worked for me.

I copied and pasted the text into single cell table with which I have replaced the text box. I have had no particular difficulty in placing the table on the page in its desired position.

Inserting a clip art image created space to accommodate the image but the image appeared above the table and will not remain in the cell whatever method I use to place it. But the space for it persists!

I am using a newsletter template downloaded from microsoft.com. Perhaps the problem relates to some quirk in the way the template has been constructed?

Malcolm,

The minimum margins are set by your printer driver. If you are intending to print this page on an A3 printer then the best approach would probably be to install the drivers for the target printer and set that as your default.

One approach I have used is to set my default printer to be an Acrobat printer, set to the correct page size.

Thank you Stuart and also Hans for your expeditious assistance.

Malcolm

Try an iframe. I have done this with a PDF and it worked but I didn’t think the result was elegant.

Thank you Stuart for your further response,

In view of your comparison and in hindsight perhaps I should have typed `I have carried out the tests and checks detailed by StuartR that I have deemed appropriate’. As I have no wish to introduce user names and passwords onto my computers I will let the matter rest and continue with the one-way access I `enjoy’ now. {8;-))

Thank you very much for your input – I appreciate it very much indeed.

Stuart – Thank you for your response

>This article tells you how to change the node type, but I doubt that this is the cause of your issue. I suspect there is something wrong with the share permissions, file permissions or the user account you are using on the laptop.Can you please confirm that you log in to the laptop and the PC with the same user name and password, and that this user definitely has access permissions to both the Share and the shared folder.<

I do not have to log in to the computers – neither is password protected as I am the sole user and both computers have one user with an administrator account. The user on the desktop is `Malcolm' and on the laptop the user is `Malcolm-LT'.

Please can you explain about what you mean by `has access permissions to both the Share and the shared folder.'? I have shared certain folders on both computers but what is `Share'?

Joe – Thank you for your response. I will be checking the network later and will refer to the articles you have pointed me towards.

My thanks for your quick response and solution. Yes one table was my aim and my tables are now all joined up. I had never before realised the difference between Normal and Print View and I have been using Word for some 14 years!

Steve and Tom D,

Thank you both for your responses to my request. I have exactly what I need particularly Steve for the extended formula for the running balance. When and if I have to insert a transaction Tom I do realise that the formula needs to be entered in column E and as in other worksheets I use I can do this by dragging the cell contents down.

Thank you both again for your guidance.

Malcolm

Thank you for your erudite commentary; not only interesting but pertinent. How could the discrepancies between browsers have arisen and will they ever be resolved?

[indent]

---

Got you,OK,I’ll be frank I personally wouldn’t use a table then in this way. However if you have got a website that has a load of tables already set up the I suggest that you set the table to be a fixed width of say 600px and then let the .roundedcornr_box_469779 be 630px.

---

[/indent]

Dear Jerry,

The site was started with FP 98 and has grown since then. This is a part of the site that records, mainly, competition results and as a means to an end at the time tables seemed appropriate. There are some 100 of these tables, two to each page and if any two of them are the same height and width I’d be pleasantly surprised.

So you would have used lists – I’ll have to think about that as a possibility. BTW I am not using tables for the layout of these pages.