Search results for query: *

What you want to do isn't very clear, but this is how you merge and set all the cells in the merge to wrap text. RangeString = "C27:E34" ' you can construct this string any way you want to. Range(RangeString).Select With Selection .HorizontalAlignment = xlGeneral...

Can't you just do something like: GimmeTheValue = Workbooks(&quot;Workbook1.xls&quot;).Worksheet(&quot;<SheetName>&quot;).yourPublicVariable ? U might have to tinker with it.. like sometimes it has to be Workbook instead of Workbooks... this is off the top of my head. Basically u need to get...

Basically you want to have a double loop something like this, I use a user-defined type for my array, but u can get an idea: Public Type namesArrayType names(10) As String spent As String End Type Public Sub DisplayArrayOnSheet(currentArray() As namesArrayType, sizeOfArray As...

It sounds like u just want to do the same thing as selecting a range of cells with a cursor. Basically all u have to do is: Range(A1:Q20).Select that highlights all the cells from A1 to Q20 in a box. Btw, an easy way to learn VBA is to select the Macro tab and Record a New macro. Then do...

I don't see why not... why not try it yourself? there is a couple build in functions for forms like: Private Sub UserForm_Initialize() End Sub and Public Sub UserForm_Activate() End Sub you could modify the forms property in these methods. They will get run either when the form is first...

Do While (ListBox1.ListCount >= 1) ListBox1.RemoveItem Loop Pretty basic =)

Uh, how are you attempting to move it? I'd just set the cell's data to a varaible and then move it. i.e. Dim tempVariable As String tempVariable = SheetCodeName.Range(A6).value SheetCodeName.Range(A7).value = tempVariable No matter what is in the cell, it will be moved.

Why not just create a Sub that is called saveWorkbook in the module your Macro is in. Then put your code for saving in there. Then once the progress bar finshes you can call, for example, module1.saveWorkbook. -cLocKwOrkPRO