Can someone please test this VBA line...

Roopher

Roopher

Board Regular
Joined
Jul 8, 2008
Messages
73
Hello, can please someone tell me what's wrong with this line, executed in the Immediate Window of the Excel 2007 IDE. My Excel commences an infinite loop... -> until task manager kill.


Code: 
Activesheet.Columns("A:C").ColumnWidth=Array(5,15,50)


Regards,
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
Sort by date Sort by votes
This is just a repeat of this question. Please don't keep posting the same thing!
 
Upvote 0
You must log in or register to reply here.

Similar threads

E
  • Question
Can anyone help me get my VBA code working? I have spent tons of time but can't quite fix it.
Replies
3
Views
2K
profray
P
AOB
  • Question
Detect "Office" dialog which is stalling VBA ("This experience is unavailable")
Replies
2
Views
1K
AOB
AOB
D
  • Question
VBA Changing Pivot Cache Run Time Error 5
Replies
0
Views
1K
Dichnich
D
L
  • Question
Code works except when power query is used
Replies
0
Views
1K
lisam77
L
N
  • Question
Error 424 when passing a VBA array to a function as a ParamArray input
Replies
1
Views
1K
ZVI
ZVI

Forum statistics

Threads
1,214,426
Messages
6,119,417
Members
448,895
Latest member
omarahmed1

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top