the data I am copying always lies in A1:F5
On the last day of the month I need to copy B1:F5 to B10:F15 and put the
month name in B9; after that it would go to the next empty column (in this
case E) and paste again for the next month.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do y
Still getting error 462 every other time I run the macro. not sure how to
beat this error.
On Monday, October 21, 2013 8:21:02 AM UTC-7, Justin Pulley wrote:
>
> I don't know how to mark something uncompleted.
>
> The code works every other time.
>
>
>
> Sub Cre
I don't know how to mark something uncompleted.
The code works every other time.
Sub CreateReportPDF()
Dim wdapp As Word.Application
Dim wddoc As Word.Document
Run CopyData
Set wdapp = Word.Application
Set wddoc = wdapp.documents.Add
Application.ScreenUpdating = False
wdapp.Visible = True
Nevermind, I got it. For some reason there was a bunch of used rows in
there.
On Friday, October 18, 2013 7:21:50 AM UTC-7, Justin Pulley wrote:
>
> So I am going to have to upload the entire sheet I guess because when I
> run your code in the full workbook I end up with 5 blank pages
e (coding).
>
>
>
> *From:* excel-...@googlegroups.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Justin Pulley
> *Sent:* Thursday, October 17, 2013 12:02 AM
> *To:* excel-...@googlegroups.com
> *Cc:* koul@gmail.com
> *Subject:* Re: $$Excel-Macros$$ VBA
ps.com [mailto:
> excel-...@googlegroups.com ] *On Behalf Of *Justin Pulley
> *Sent:* Thursday, October 17, 2013 12:02 AM
> *To:* excel-...@googlegroups.com
> *Cc:* koul@gmail.com
> *Subject:* Re: $$Excel-Macros$$ VBA for Excel to Word
>
>
>
> I have manually move
Is it possible to write a macro that exports two worksheets out of a
workbook to Word? currently I export to .pdf which I thought was fine, but
my boss asked for an export to word.
The challenge is one of the worksheets contains charts that need to go with
it.
current code
ThisWorkbook.Shee
It is somehow attached to the first post in the thread, you'd have to
expand all threads to see it.
On Saturday, October 12, 2013 7:36:09 AM UTC-7, ashish wrote:
>
> attachment is missing
>
>
> On Fri, Oct 11, 2013 at 3:48 AM, Justin Pulley
>
> > wrote:
>
&
I guess what I am asking is way more complex than I thought, I can't seem
to get a push in the right direction anywhere.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discu
Was the attached file what you were looking for?
On Thursday, October 10, 2013 8:44:55 AM UTC-7, ashish wrote:
>
> can u pls share a sample workbook?
>
>
> On Thu, Oct 10, 2013 at 9:05 PM, Justin Pulley
>
> > wrote:
>
>> Here is my current code:
>>
>
Here is my current code:
Code:
Dim sh As Worksheet, sh2 As Worksheet
Dim LastRow As Integer
Dim LastRow2 As Integer
Set sh = Sheets("Raw ATS Data")
Set sh2 = Sheets("ATS Data")
With sh2
Range("A2:H" & Rows.Count).Clear
End With
LastRow = sh.Range("A1").End(xlDown).Row
sh.Range("A1:H" & La
11 matches
Mail list logo