Dear All,
I am trying prepare a Calc file for my soccer team (to record training
sessions, matches and co)..
I have some questions:
1. as far as the conditional formatting is concerned, is it possible to say
if a1 is empty, then the cells in the row one does not have any borders?
How can I do
Dear All,
I am trying to insert in a cell (let's say A1) the file name (without the
path and - if possible - without the extension).
I have tried
thishttp://office.microsoft.com/en-us/excel-help/inserting-the-current-excel-file-name-in-a-cell-HA001034627.aspx,
but it does not work: Err.501
I solved it with this formula:
=REPLACE(REPLACE(CELL(filename);FIND(.;CELL(filename);1);(LEN(CELL(filename))-FIND(.;CELL(filename);1)+1););1;SEARCH(/[^/]*$;
CELL(filename));)
I like it!
On Fri, Oct 19, 2012 at 4:06 PM, Jay Lozier jsloz...@gmail.com wrote:
On 10/19/2012 08:41 AM, Samuele
Dear All,
I am trying to write a macro in order to create some sheets once it is
invoked (e.g. through a button).
Sheet 1 contains a list. So cells in the first column contains a name:
A1 = player1
A2 = player2
A3 = player3
A4 = player4
A5 = player5
A6 = player6
..
An = playern
where n may