Question: I'm currently trying to pass to a user defined function in excel the contents of an cell as argument.

Namely, i calculate the range i'm interested in a cell, where i get something like this "sheet1!X17:X37".

Now i want to pass this cell (e.g. A1) to a udf. For example i want in B1 to have "=myfunction(A1)" as opposed to "=myfunction(sheet1!X17:X37).

Any ideas?

My function is like this:

```
Public Function ConcatItNoDuplicities(ByVal cellsToConcat As Range) As String
    ConcatItNoDuplicities = ""
    If cellsToConcat Is Nothing Then Exit Function
    Dim oneCell As Range
    Dim result As String
    For Each oneCell In cellsToConcat.Cells
        Dim cellValue As String
        cellValue = Trim(oneCell.Value)
        If cellValue <> "" Then
            If InStr(1, result, cellValue, vbTextCompare) = 0 Then _
                result = result & cellValue & ","
        End If
    Next oneCell
    If Len(result) > 0 Then _
        result = Left(result, Len(result) - 1)
    ConcatItNoDuplicities = result
End Function

```

Best
T

Answer: 
The root of the problem seemed to be that I had an issue with `app.py`. I was using some Flask library that I had installed on my local machine but not the server and for some reason I didn't get big errors when I ran the server via `flask run --host=0.0.0.0`.

I figured this out by adjusting supervisor `.conf` file which is located at `/etc/supervisor/conf.d/Server-CardLearning.conf`

The new `.conf` file reads:

```
[program:Server-CardLearning]
environment=SECRET_KEY="some_secret_key"
command=gunicorn app:app -b localhost:8000
directory=/home/alexg/www/Server-CardLearning
user=alexg
autostart=true
stderr_logfile=/var/log/supervisor/test.err.log
stdout_logfile=/var/log/supervisor/test.out.log

```

By adding the two log files I was able to run:

`cat /var/log/supervisor/test.err.log`

to see that I had an uninstalled library! ~Gasp!~

After installing the library, I ran:

```
sudo supervisorctl reread
sudo supervisorctl update
sudo supervisorctl start Server-CardLearning

```

Now, if that doesn't fix it, I also found that digging around in the supervisor console was helpful:

```
$ sudo supervisorctl
supervisor> help
supervisor> status

```

I hope this helps someone out!
In my case accidentally i removed the logs folder where the supervisor logs was pointing to so creating those folder and restarting the supervisor did the trick.

Sample supervisor.conf

```
[program:Server-CardLearning]
environment=SECRET_KEY="some_secret_key"
command=gunicorn app:app -b localhost:8000
directory=/home/alexg/www/Server-CardLearning
user=alexg
autostart=true
stderr_logfile=/var/log/supervisor/test.err.log
stdout_logfile=/var/log/supervisor/test.out.log

```

So all i did was :-

```
mkdir /var/log/supervisor/

```

after that :-

```
sudo supervisorctl status all

```