Installing Atom on Ubuntu encounters errors with gvfs-bin

Question

I am trying to create a macro button that will help me update the the value in the AE column to "N" if the value in the same row of the H column is "REPO".

I am not sure why my code doesn't work properly and just seems to select the AE column when I run it instead of changing the values to "N"

Sub Change_Repo_Risk_to_N()     

    Sheets("expo").Select    
    Dim LastRow As Long    
    Dim i As Long    
    LastRow = Range("H" & Rows.Count).End(xlUp).Row

    For i = 2 To LastRow           
        If Range("H" & i).Value = "REPO" Then    
            Range("AE" & i).Value = "N"    
        End If   
    Next i      

End Sub

Solution

Known issue with package depending on deprecated no longer available gvfs-bin.

Been fixed in beta and nightly.

If you still want to install atom release 1.52.0 on newer Ubuntu, then download the deb package and install with:

sudo dpkg --ignore-depends=gvfs-bin -i atom-amd64.deb

Comments

[cat]

try running dpkg --configure -a; sudo apt-get install gvfs-bin gvfs-common

[David Foerster]

What's the output of apt-cache policy gvfs-bin gvfs-common?

[ouroboros1]

Works just fine with me. Maybe running through the code line by line (use F8) may help you to locate the problem? Also, try to avoid Select (see: stackoverflow.com/questions/10714251/…). Perhaps the ranges you have in mind aren't actually inside Sheets("expo")?

[minigeek]

If software-properties-gtk is not installed..install it after this process using sudo apt-get install software-properties-gtk

[Kat K]

Thank you for your help and advice! I think the Trim function was what I was missing! Everything works fine now :)