Users browsing this issue:
None
Is there a simpler way to add the same point code to several different objects in a specific series? For example I would like to add point code that specifies series "A" to points 13, 25, and 28 on object B, to points 42, 42 and 42 on object C, to points 53 and 56 on object D, and to point 41 on object F. Also the points must be in the same order on each object.
Hi,
I'm a new user, but I have read some of your posts and found them very helpful, especially the one about dates in excel.
I'm hoping you can help me with a very easy task. I've been trying for 2 weeks and I'm lost. I'm not looking for much - just an explanation of what's going on so that I can figure out how to do it myself.
I have a list of contracts and each contract has a date. For each date I need to copy a block of text and paste it into a specific spot. I do not want to change the font, but I do want to change the background color and the font.
I've looked at the 'PasteSpecial' and 'Paste & Match Style' but neither of them do what I want.
Here's a little routine I created.
The routine copies cell A2, but inserts a space in front, copies A4 and inserts a space in front, copies A6 and inserts a space in front, and copies A8 and inserts a space in front. The result is a path that looks like this:
SJTU/DS/DJTU/SJTU
I've also created another function that will insert spaces in a specified column, so that you don't have to manually adjust the column numbers.
Private Sub PasteSpaces()
Dim rng As Range
With Sheets("Sheet3")
rng =.Range("A2:A8")
With.Range(.Cells(rng.Row + 1, 1),.Cells(rng.Row + 1, rng.Column))
.ClearContents
.Font.Bold = True
.Interior.ColorIndex = 1
End With
End Sub
On the Excel home page, select "Developer".
Click "References".
Check "Microsoft Forms 2.0 Object Library" and then 3125841983

Downloadaccounthackerv399activationcode EXCLUSIVE