Microsoft Office Forums - View Single Post - Object Variable or With block variable not set

Thread: Object Variable or With block variable not set

View Single Post

Old

01-08-2015, 12:37 AM

gmayor

gmayor is offline

gmayor uses Windows 7 64bit

Windows 7 64bit gmayor uses Office 2010 32bit

gmayor uses Office 2010 32bit

Office 2010 32bit

Expert

Join Date: Aug 2014

Posts: 4,137

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

gmayor has much to be proud of

Default

You have set the range with

Code:

Range(Cells(1, 1), Cells(4, 1))

the first number in the bracket is the row, the second the column, so your example sets the range as A1 to A4

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com

Reply With Quote