Search For:

Thank you I will give it a try.

my solution is less elegant. I found that if I changed sheets to the copy from sheet it worked fine.

I just don't like the fact I had to do it. It is not...

Ok I thought it worked but it appears as if the copy part fails if I am not on the sheet "Scratch_Sheet"

So back to my question, What is wrong with coping data from another sheet? is there a...

Sheets("Scratch_Sheet").Range(Cells(1, 1), Cells(1, 7)).Copy
Sheets("Summary").Cells(1, 1).PasteSpecial


Seems like there are many ways to skin a cat. Looking around the varying solutions on...

Sheets("Scratch_Sheet").Range(Cells(1, 1), Cells(1, 7)).Copy
Sheets("Summary").Range(Cells(1, 1), Cells(1, 7)).Paste


Ok what is inherently wrong with this? I am trying to copy a range of...

That is funny because the code was written years ago and it is what I got from a modified recorded macro. I guess they changed that for some reason.

oh well, thanks.

Ok what did you change and why?

what is inherently wrong with this code?


rowcount = 561
A = 0
Cell(A) = 115,1 'cell is an array containing many text strings. 0 is the first one.

Set tst = Range("a1:a" &...

thanks I will try it and get back to you.

Dude this is really funny trying to type with double vision.

I just had work done on my eye after weekend auto work and subsequent eye work to remove...

My only question is what do I have to do to get this to work.

When rws = 65535 it works
when rws > 65535 it fails. with a "run time error 13 type mismatch error."


rws = 67000 right now
clmn...

Set pt = ActiveSheet.PivotTables("PivotTable1")

pt.ManualUpdate = True

pt.ManualUpdate = False


sorry wrong answer. I did not read the question properly

I do not think it is shared.

it is a workbook on my hard drive that I launch every morning...

nope no one is sharing it. Standard xls that runs if I disable the splash screen when locked but...

well by locking itself I mean when the screen saver password kicks in requiring the user to ctrl alt delete use password to unlock. the IT security policy uses this to secure terminals when people...

I have a splash screen which allows the user to interrupt the start of my macro. my machine is forced by IT to lock itself after 30 minutes. While in locked mode the splash screen starts but the...

wow thanks guys.

I appreciate all your help and your bearing with my ignorant questions!

I love this site.

actually I have simply copied all spread sheets and all code to new workbook and saved it and poof all is well with the world.

the original sheet was created in office 2003 and I am working in...

I have a spread sheet with a macro attached to it, approximately 500 lines of code and 3 sheets approximately 30 rows by 30 columns.

it recently shot up from 130 KB to 15,000KB. Do I need to...

thanks man you are the bomb. i will try it.* Auto Merged Post Until 24 Hrs Passes;*can you explain why my code would not work. I simpy do not understand what is wrong with PvtDest.Cells.Select ...

PvtDest is the remote sheet.

I am running the macro from an interface workbook.

I will call that update.xls

I want to copy/paste special values to the same sheet my pivot table workbook...

I am trying to be a good programmer and not do a whole bunch of activate workbooks and worksheets blah blah blah. So I am 99% complete with my subroutine and stuck on 3 lines. I need to copy my...

Well that about does it. Thank you Dave Hawley that manual update is smoking.

Pivot time down from like 3 minutes to 10 seconds.

I am using the following loop populate the fields of my pivot table.


For x = 2 To 10
ActiveSheet.PivotTables("PivotTable1").AddDataField ActiveSheet.PivotTables( _
...

thanks for the linky

I have a link which constantly asks to be updated but there should be no link. apparently it is a left over from a copy I did but I am unable to find the link in office 98

So the long and short...

No Ideas???

Every night around midnight I start a process to update my reports.

When the macro launches it has a splash screen to allow user to break out of the macro if required. The splash screen comes up...