add one more dim statement as below
Dim d1 As String
Dim d2 As String
Dim d3 As String
Dim d4 As String
Dim full_dir As String
On Thu, Feb 4, 2010 at 12:44 AM, Dave wrote:
> Thanks for the help I am getting a compile error when I run the code.
> the error is "ByRef argument type mismatch"
I understand we can use conditional formatting to create heatmaps in
Excel 2007. Here's what I need:
Have a "Region" dropdown tied to a "Areas" heatmap graph. When I pick
a particular "Region" value, the heatmap graph should display, say
population, of all the "Areas" within that "Region".
Is t
I have some data where one column represents time. A second column
represents the amount of data that I am measuring.
I want to create a histogram chart and I came across the frequency
function in Excel. This is close to what I want but instead of
outputting frequency I want to sum up the amount o
In my experience, adding forms directly to Excel sheets causes issues
like this to occur. The only fix I've discovered is the one you came
up with below (or similar approaches). You may find that focusing a
particular dropdown will cause the problem to reappear, in which case
you'll also need to
hi check the attachment
On Wed, Feb 3, 2010 at 1:39 PM, vicky wrote:
> volume sales
> 1.13 2423
> 1.532423
> 2.92 33243
> 1.47 3243
> 1.49 234234
> 1.35 343423
> 3.45 32423
>
>
> i need top ten sales values for volume > 1 and volume < 2
>
> --
>
> -
Now i want to open same webpage 10 times in 10 different tab in IE 7.
How do i do that.
Thanks,
Sandeep
On Wed, Jan 20, 2010 at 5:43 PM, Anil wrote:
> do not forget to add this line at the starting
>
> Dim oBrowser As New SHDocVw.InternetExplorer
>
> On Jan 18, 11:08 pm, Sandeep Kadam wrote:
Thanks for the help I am getting a compile error when I run the code.
the error is "ByRef argument type mismatch" & it highlights Call
searchsub(full_dir)
On Feb 2, 8:20 pm, KC Cheung wrote:
> Air code, not tested
>
> Sub all_2010()
> ' Macro to searh & display PDf files
> Dim i As Long
> dim d1
Hi,
Don't quite understand your requirement.
You want to insert 3 new columns into F,G,H, but you want to retain the current
column H as it is. If you insert 3 columns at F,G,H, current Column H will
become Column K, and current Column I will become Column Column L.
Regards - Dave.
Date:
I fixed it, without finding the root cause:
Private Sub Workbook_Open()
For Each ws In Worksheets
For Each dd In Worksheets(ws.Name).DropDowns
dd.Height = 15
Next
Next
end sub
It is not a good way, but it works. If anybody has an idea what the
root cause ist, please post it!
--
-
volume sales
1.13 2423
1.532423
2.92 33243
1.47 3243
1.49 234234
1.35 343423
3.45 32423
i need top ten sales values for volume > 1 and volume < 2
--
--
Some important links for
I hope that below code is your need but if it isn't your need please
send me a file about it..
Sub colorcontrol()
a = InputBox("which range is starting your table? for example : A1")
Range(a).Select
Do While Not IsEmpty(ActiveCell)
If ActiveCell.Interior.ColorIndex = 3 Then
If MsgBox("che
Hi Ayush,
Do the following steps
1. crate a function for your range
ex:
Public Function nRange() As Range
'Dim rng As Range
'Set rng = Sheets("M-RAW").Range("A1:A15")
Set nRange = Sheets("M-RAW").Range("A1:A15")
End Function
2) Now call this function where you want to use the defined range
ex:
12 matches
Mail list logo