can be used for pasting html block in a cell after word
Thetarbre's List: Tips
-
-
May 02, 12
Private Sub Worksheet_Activate ( )
Me.ScrollArea = "A1:G50"
End Sub-
Private Sub Worksheet_Activate ( ) Me.ScrollArea = "A1:G50" End Sub
-
Sub ResetScrollArea( ) ActiveSheet.ScrollArea = "" End Sub
-
-
May 03, 12
Cells.Replace What:="d", Replacement:=Chr(10), LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
K-
Cells.Replace What:="d", Replacement:=Chr(10), LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False -
-
-
-
-
Move Instead of Copy
Finally, copying the files is useful, but sometimes the better operation is to move the files, rather than preserving the original files in their original locations. The Windows command prompt provides a command for moving files (MOVE), and it can be used in place of the “COPY” command used in the earlier examples.
The following command will move all of the files from the Folder0 hierarchy into DestFolder:
for /r C:\Folder0 %f in (*) do @move "%f" C:\DestFolder
There you have it. Simple, fast, and requires nothing more than a command prompt. Wonder what other command line goodies I’ve been ignoring?
-
-
-
-
-
Alternatively, you can use the find & replace feature to update all the fields at once. If each field contains text like "myaudio", and you wish to make it play a sound, you’d search for (.*) and replace it with "[sound:$1.mp3]", with the regular expressions option enabled.
You might be tempted to do this in a template, like:
-
-
1 - 16 of 16
20 items/page
List Comments
(0)
List Info
16 items | 2 visits