Search:
Type: Posts; User: InderpalHothi
Search:
Search took 0.01 seconds.
-
All,
Following formula gives me an application defined or object defined error:
ActiveCell.FormulaR1C1 = "=min(R" & rowr & "C" & week2locform & ":R" & rowr & "C)"
whereby rowr = 2 (will not...
-
Can someone please help with the attached document?
With regards to the attached document, the cell highlighted in yellow,has the following formula:
...
-
thanks, will give this a try and mark resolved if it works...
-
Hi guys,
i am fine with sub routines, first time i am trying a function.
Function Value1(ByRef p As Range, ByRef d As Range) As Variant
If p.Value = "" Then p.Value = 0
-
Object required error.
FileLoc range has been set to the exact file path.
If I combine the whole thing in one subroutine as such:
Public Sub Declarations()
Dim wb As Workbook
Dim wbS As...
-
Guys,
Don't know what is going on with this code - is there a problem with my vba?
Public Sub Declarations()
Dim wb As Workbook
Dim wbS As Workbook
-
cheers, problem sorted.
Used :
If Utime>dTime and Dtime>Ltime
etc
-
-
Hi guys,
I have set up a windows scheduler even to open a specific file every friday at 9.30am.
I now would like to set up a workbook_open event which generates an email when the scheduler...
-
Hi guys
I have calcualted the first and last rows being used in a sheet.
FirstRow and LastRow are variables which will change frequently.
I now need to autofill a formula i have to cover...
-
-
Hi guys,
I need some help with a macro that opens files with a variable file name (want to copy data from).
The file always has the same first part of its name, but a different stamp based on...
-
vbfbryce - no problem on this one, dno whats going on then. Thanks for your help again!
westconn1 - thanks aswell, duly noted re the 'or' point
-
yeh, there are duplicate values in column E, but it seems to be only taking one instance.
This is fine, I was just wondering why it was doing this
-
Hi guys,
Got this code below where ws1/2/3 etc makes reference to my worksheet. All stuff is defined.
Dim i As Long
Dim RwCount1 As Long
-
-
same problems still exists!
-
Vbfbryce,
The code you post is great and has given me a lot of insight, but for some reason in the excel example you posted it only cuts he first two rows out and doesnt go on to check the values...
-
-
-
Vbfbyce,
Thanks for your response.
To clarify:
Imagine i have a spreadsheet filled with values on a type of financial product. Column F in the instance above contains the name and date...
-
Hi guys,
I had previously posted on this forum to try and get some help with the following problem but I didnt really get any meaningful help... I have refined the code but I would greatly...
-
Cheers.
The thing I am struggling with is cutting the range of rows which meets the criteria
-
Yes sorry- cut the entire rows that meet this criteria and paste in another sheet
-
Unfortunately I have not got very far so far, this is what i have...many thanks for your help btw
Dim ISIN1 As Variant
Dim Dte As Variant
Dim NetAmount As Variant
Dim FirstRow As Long
Dim...
-
Seenu,
I am running Excel 2007 so I am guessing VBA?
-
Hi Guys,
I am a newbie to VB and would like some help re a Sub I am trying to create if possible in excel. The aim is:
-Check the values of column E
-If any two or more rows have the same...
|
Click Here to Expand Forum to Full Width
|