First, thanks in advance for any help you can provide.
I am trying to build a macro that will take the information entered in one
sheet and, based on the date, put the information into the appropriate cell
in a different sheet.
For instance, I want information in Worksheet1:B4 stored in
Work
les in the
original workbook. Now, I'm abandoning the add-in in favor of
including the code which pertains to the worksheet in the worksheet
module itself and then saving it along with when I "cleave" off the
worksheet.
That seems to be working for me. Thanks again.
Doug
On Oct 2
meone please tell me how to set the reference to a custom made
add-in automatically through code?
Thank you.
Doug
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel an
Paul,
I placed the string in the Workbook_Activate sub in the ThisWorkbook
module and it works.
Thanks.
Doug
Paul Schreiner wrote:
> Not sure why it doesn't work for you.
>
> I did this:
>
> In a module I called "Declarations", I added:
>
>
> Public V
Scratch my last post. Now it seems to be working.
Thanks anyway.
Doug
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free
I'm so annoyed at myself! I recorded a quick macro just to take a look
at the code it wrote and I named it "Format". Now Excel is not
recognizing it's own Format() function. How can I restore the original
fun
t IDOSheet As String = "Init " +
Format(Now(), "m-d-yy")
but I'm getting the error message: Constant expression required
I'm guessing that
Paul,
That worked great. Thanks!
Doug
Paul Schreiner wrote:
> The problem is that you're not telling
> VBA to use the VALUE of the variables,
> you're telling it to use the CHARACTERS
> in the NAME...
>
> what you need to do is "BUILD" the range like this
ge like this:
>
> Range("C10:" & rCLR & ", D10:" & rDLR & ", G10:" & rGLR).Select
>
> that says to use the literal string "C10:" and add the VALUE
> of the variable rCLR followed by the literal string ", D10:"
> e
:
Range("C10:rCLR, D10:rDLR, G10:rGLR ").Select
Or am I going about it the wrong way?
Thanks,
Doug
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel
to be reissued.
> You have essentially "ASSIGNED" to variable OldRange
> to be whatever Target happens to be.
>
> If you're wanting OldRange to retain it's value
> unless or until you change it, get rid of the word "set"
> (notice that:
> OldValue
he value in the cell immediately to the right of the initial
cell, and if I call the variable elsewhere it has that same incorrect
value!
Can someone please enlighten
OK. Thanks for the input, Dave.
On Jul 3, 1:04 am, Dave Bonallack wrote:
> Hi Doug,
>
> All formatting can be done through VBA.
>
> But if you want the formatting applied to each cell as you click on it, then
> you need an event macro, which needs to reside in the code windo
Dave,
That's exactly how I'm doing it now. I'm just wondering if each cell
could call a sub that would do the formatting on the fly and not hard
code it with each sheet. If there would be any advantage if it could
be done.
On Jul 1, 10:29 pm, Dave Bonallack wrote:
> Hi Doug,
&
Just a quick question.
I'm writing a workbook in which a new worksheet will be added every
day. Each worksheet contains a number of cells with the same
conditional formatting applied. Is there any advantage to applying the
formatting through VBA code as opposed to applying it through the
Format
in private subs:
Dim IR As Range
Dim FR As Range
Set IR = Range("D10:D200")
Set FR = Range("G10:G200")
Isn't there a way to declare these publicly so that I don't ha
This code wasn't quite right and it was giving me errors.
I found the problem was in this line: " if date(Range("B2").value)
=dtdate then "
I corrected it to read " if Range("B2").value=dtdate then " and it
works fine!
Many Thanks!
Hello,
I have a workbook with a separate page for each date. The date is
always in cell B2. On the first page of the workbook I want to enter
the date into a cell named "IDO_Date" and click on a button to go to
the worksheet for that date. Can someone please show me the easiest
code to assign to
If Intersect(Range("C:C"), Target) Is Nothing Then
> 'do nothing
> Else
> MsgBox "it is changed"
> End If
> End Sub
>
> You can do many thing by just clicking a cell in column C (in this example).
>
> Akhilesh Kumar Karna
if I could just press Enter from the correct cell.
Is it possible to run a macro by simply hitting enter on a cell
without even entering any data in the cell? The active cell will
always be in column 4.
None of the answers I found online so far work for me.
Th
Dave,
Thanks. With a little bit of tweaking that's just what I needed!
Doug
On May 5, 10:12 pm, Dave Bonallack wrote:
> Hi, try this code somewhere in your sub:
>
> With Range(A1:A1000)
>
> D = "Seed-BOD"
> Set C = .Find(D, LookIn:=xlFormulas)
>
Seems easy enough but I'm new at VBA so I can't seem to get it right.
I have a sub that adds a row to my worksheet but this particular row
needs to be unique. So all I want to do is call a function that will
search the first column of the active worksheet for the string "Seed-
BOD". If it finds t
Thanks Harmeet, worked perfectly and a definite improvement on my
solution.
Regards,
Doug Jacobsen | Staff Business Analyst, OM
From: Harmeet Singh [mailto:harmeet.hew...@gmail.com]
Sent: Saturday, March 21, 2009 5:48 AM
To: excel-macros@googlegroups.com
Cc: Jacobsen, Doug
Subject
Is there a way to search or sort the discussions so I can easily find
one that I started?
Regards,
Doug Rohr
(330) 471-4164
-
This message and any attachments are intended for the individual or
entity named above. If you are not the intended
24 matches
Mail list logo
