---
> From: vivek agrawal
> Date: Tue, Jul 21, 2009 at 3:41 PM
> Subject: Re: $$Excel-Macros$$ Re: Fill In Rows - Efficiency
> IssueTo:excel-macros@googlegroups.com
>
> Hi Dustin
>
> I didnt go through your code but given below is the code which i feel does
> the re
for future reference.
Granted, using the IE workaround, one cannot control the file /
application being opened (I believe?), but its a fine workaround if
all you need to do is open i
Dear Group,
I currently have an excel spreadsheet that is used as an invoice
template. A loop goes through each customer and the invoice reflects
their customer specific information.
I am looking to move over to a mail-merge solution for this, and I
need to convert my excel worksheet to a word t
No thoughts on this at all?
On Jul 2, 12:54 pm, Dustin wrote:
> Hi Everyone!
>
> The following code works (not the best), but is inefficient, in my
> opinion. It takes a few minutes to run, which is unacceptable. I am
> looking for a re-think about how this can be done in order t
Hi Everyone!
The following code works (not the best), but is inefficient, in my
opinion. It takes a few minutes to run, which is unacceptable. I am
looking for a re-think about how this can be done in order to make it
run faster.
The code looks at a table that is in order chronologically, but no
py _
> Destination:=Worksheets("Output").Range(dest_col & 1)
>
> Akhilesh Kumar Karna
>
> On Thu, Jun 11, 2009 at 3:10 AM, Dustin wrote:
>
> > Hello Group,
>
> > The code at the end of this post does not work, but I made it to be
> > the best appr
n their respective worksheets, input and
output.)
I cannot seem to get this reference to read correctly though. Any
Thoughts? Thank you!!
Dustin
code:
Sub MoveColumns()
Dim countnonblank As Integer, myRange As Range
Se
I was not able to get this to work. I have heard that PDF creator has
hooks in it for this kind of thing, but I have not investigated that
yet.
On May 21, 11:05 am, Dustin wrote:
> I'll try that out and get back to you.
>
> For this example, creating multiple print jobs is tri
t;
>
> But I wonder whether there is any specific reason to avoid sending 11
> separate print jobs (in your example).
>
> Akhilesh Kumar Karna
>
> On Thu, May 21, 2009 at 2:08 AM, Dustin wrote:
>
> > Akhilesh,
>
> > Thank you for your response. Though that line is help
at this is currently written, there will be 11 separate
print jobs sent to the printer, resulting in 11 pages.
What I would like to do is to have only ONE print job sent to the
printer, which will result in 11 pages. Does that help?
Dustin
On May 12, 2:10 am, Akhilesh Karna wrote:
> Maybe I got
than ideal since the invoice is now a picture
instead of a table which can be edited.
I am certainly open to any other way to accomplish this as well.
What are your thoughts on this?
MUCH appreciated =] ... I love
experience away, my friends! lol.
On Apr 24, 7:31 am, Paul Schreiner wrote:
> Dustin,
> it looks like you've had several replies to your question.
> I tested it, and it looks like Habeeb's answer works just fine
> (except for needing a couple of spaces:
> Worksh
e("A4701:CE4900").Copy _
Destination:=Worksheets("ExecServices").Range("A" & iNextRow:"CE" &
iNextRow)
but this returns an error any way I try to do it.
I love this group and I have a lot of faith in you guys already =
ate number in the new row
offs = offs + 1 'increase the offset value by 1
'MsgBox offs 'print the offset number for verification
End If
Loop
End If
End Sub
On Apr 21, 6:20 am, Dave Bonallack wrote:
> Hi Dustin,
> Paste
hanks!
Dustin
Sub fillInTheRows()
Sheets("Raw").Select
Range("A1").Select
Dim Count As Integer
Count = 100
Dim rowCount As Integer
rowCount = 1
Dim offs As Integer
offs = 1
upperLimit = 4999
Application.ScreenUpdating = False
'Check to see if the data is there...
If
109
110 this is 110
...
I would super appreciate help with this!
Thanks!!
Dustin
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video
16 matches
Mail list logo
