Search results
-
H
Interior.ColorIndex of a Range
Dim ws As Worksheet Set ws = Application.Worksheets(“test”) Set r1 = ws.Range( ws.Cells(9, 2), ws.Cells(EndRow, 20)) Set r2 = ws.Range( ws.Cells(9, 22), ws.Cells(EndRow, 26)) 'Set r3 = Union(r1, r2) - this do not work…? r1.Interior.ColorIndex = xlNone - this is not possible??- Helnora
- Thread
- Replies: 4
- Forum: XLS Padlock
-
H
Call function in another function
In the VBA compiler I call another function also inside the VBA compiler. I do not get errors when compiling. I get the following error, but do not understand what is wrong.- Helnora
- Thread
- Replies: 5
- Forum: XLS Padlock
-
H
Compile 2 .exe files, changes in one .exe applies to other
I compiled one xlsm file to .exe file. Moved the .exe file to another folder and renamed it. I compiled the xlsm file again, and moved and renamed this file to another folder again. When I make changes to the sheets in the first .exe file, the changes are also made to the sheets in the second...- Helnora
- Thread
- Replies: 2
- Forum: XLS Padlock