Try...
Merge_Value = Sheets(P2).Range(E2:M2).Value
(Assuming the Cells from E2 to M2 are merged)
Best Regards,
Maddy
On Feb 10, 4:04 am, MLT mlthorn...@gmail.com wrote:
I am trying to access the contents in the merged cells E2:M2.
This works:
Merge_Value= Sheets(P2).Range(E2).Value
Why
Hi Stuart.
this may help you.
Sub DuplicateRed()
'color cells in red for duplicates in selected range
Application.ScreenUpdating = False
Rng = Selection.Rows.Count
For i = Rng To 1 Step -1
myCheck = ActiveCell
ActiveCell.Offset(1, 0).Select
For j = 1 To i
If ActiveCell =
Dear All,
I am facing a strange problem.
I have recorded the macro below but while running it is throughing
ERROR in .LineStyle = xlContinuous.
Here is the macro::
Sub PendingFormatSheet1()
'
' PendingFormatSheet1 Macro
' Macro recorded
Hi Tobi,
Try the below code. Add a reference to 'Microsoft scripting runtime'
before using the code.
Sub CreateFolderStructure()
Dim fsoobj As FileSystemObject
Dim rootpath As String
Dim rootfold As Folder
Dim fold As Folder
Dim subfold As Folder
Dim num As Integer
Dim subfoldtext As String
Hi,
Try the below code.
Sub test()
Dim bdt As Date
Dim edt As Date
Dim Weekends As Integer
bdt = 02/06/2009 19:44:31
edt = 02/09/2009 10:13:41
Weekends = GetWeekends(bdt, edt)
MsgBox ((edt - bdt) * 24) - (Weekends * 24)
End Sub
Function GetWeekends(DateFrom, DateTo)
DF = DateFrom
DT =
In the total column, try using a formula like:
Starting in row 2:
=IF(A3A2,SUMIF(A:A,A2,B:B),)
and copy it down.
paul
- Original Message
From: patrick pcnormo...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Sent: Thursday, February 12, 2009 1:55:48 PM
Hello,
For some reason in the past week or so my fill handle doesn't show up
in my workbooks. I checked that my Advanced Excel Options are set to
enable Fill Handle and cell drag and drop. And the little black
square does appear at the bottom right of the cell, but my cursor
doesn't change to