ExcelBanter - FillRight

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - FillRight (https://www.excelbanter.com/excel-programming/281429-fillright.html)

Arthur[_3_]

FillRight

Why won't this work?

ActiveWindow.RangeSelection.FillRight

It doesn't produce an error. It just doesn't do anything.

Don Guillett[_4_]

FillRight

From vbe HELP for fillright to copy a1 to a1:m1

Worksheets("Sheet1").Range("A1:M1").FillRight

"Arthur" wrote in message
...
Why won't this work?

ActiveWindow.RangeSelection.FillRight

It doesn't produce an error. It just doesn't do anything.

Don Guillett[_4_]

FillRight

I went back again and tried your code. Worked just fine when I selected a
range first. xl2002

"Don Guillett" wrote in message
...
From vbe HELP for fillright to copy a1 to a1:m1

Worksheets("Sheet1").Range("A1:M1").FillRight

"Arthur" wrote in message
...
Why won't this work?

ActiveWindow.RangeSelection.FillRight

It doesn't produce an error. It just doesn't do anything.

All times are GMT +1. The time now is 05:36 PM.