Excel version 2010
Problem:
Specific line of code is working on my workstation/version of Excel, and also for another user, but for a third user it does not. All other VBA logic works for the third user.
I am trying to find out if it is workstation related or profile related (by having the users switch PCs and check)
Background:
For a client I have created a table that is dynamic in hight, based on the entries on another worksheet. This all works, but some of the internal horizontal borders are showing which the client does not want. I therefore added this line of code in the macro
dst.Range(Cells(15, 2), Cells(15 + cLastDev, 15)).Borders(xlInsideHorizontal).LineStyle = xlNone
dst = worksheet name = (worksheets("Output"))
cLastDev = number of rows added (12)
This should remove the inside horizontal borders from B15:O27 (if cLastDev = 12). This works for a number of users, including myself, but not for all.
Any idea what could cause this?
Problem:
Specific line of code is working on my workstation/version of Excel, and also for another user, but for a third user it does not. All other VBA logic works for the third user.
I am trying to find out if it is workstation related or profile related (by having the users switch PCs and check)
Background:
For a client I have created a table that is dynamic in hight, based on the entries on another worksheet. This all works, but some of the internal horizontal borders are showing which the client does not want. I therefore added this line of code in the macro
dst.Range(Cells(15, 2), Cells(15 + cLastDev, 15)).Borders(xlInsideHorizontal).LineStyle = xlNone
dst = worksheet name = (worksheets("Output"))
cLastDev = number of rows added (12)
This should remove the inside horizontal borders from B15:O27 (if cLastDev = 12). This works for a number of users, including myself, but not for all.
Any idea what could cause this?