:
Test Range(A1)
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins
)
End Sub
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http
Sub
End Sub
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads
you're normally better to put something in the loop's test to allow
you to break out. It's normally a little easier to understand.
Regards,
Chris Spicer
www.Technicana.com
updates.
Try Googling for Excel calculation tree to see how Excel goes about
figuring out what to calculate and when.
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
--
Some
Hi LD,
Nothing springs to mind. Could you also post the
'SetPasteRangeByColumn' function, plus a sheet containing examples of
the data you're working with?
Regards,
Chris Spicer
www.Technicana.com
be quite an involved process!
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add
on licences and credits in place.
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins
-in called TechnicanaUtilities and will
upload this to the files section of this site. If you load the add-
in, it will automatically run the code each time you press CTRL+SHIFT
+A together.
Regards,
Chris Spicer
www.Technicana.com
' Distributed under the Creative Commons licence at
http
Hi All,
I recently had to give some guidance to some other developers
regarding error handling in VBA. I have put this guidance into a
short video which I thought might be helpful to developers on this
group.
http://technicana.com/vbaSection/Videos/ErrorHandling.html
Regards,
Chris Spicer
Hi Satish,
I had the chance to look at this further this morning. The following
code seems to do the trick of pasting one workbook's data under
another.
All the best,
Chris
www.Technicana.com
Sub CombineFiles()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
vMaster =
or can provide an example sheet
for us to test with.
Regards,
Chris Spicer
http://technicana.com/EasyDeeby.html
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel
I suppose you could add code to module 1 to unprotect the project it's
in, then reprotect itself once you've removed module 2. Would this be
suitable for your needs?
On Jun 4, 8:08 pm, mikeallen7 mikealle...@gmail.com wrote:
I have 2 vba modules that are both within a protected project. I
reference to the xla
addin... you should be able to remove that reference programmatically
when it comes time to distribute your workbook.
I hope this helps,
Chris Spicer
www.Technicana.com
On Jun 4, 8:08 pm, mikeallen7 mikealle...@gmail.com wrote:
I have 2 vba modules that are both within
Hi Rajesh,
If memory serves, if you open a workbook that is set to 'automatic
calculation', then open another workbook that is set to 'manual
calculation' in the same session of Excel, then both workbooks will be
set to manual calculation.
I say 'if memory serves' as this doesn't seem to occur
You're very welcome.
On Feb 23, 3:36 pm, Art rombona...@gmail.com wrote:
Chris,
Thanks a lot. I would've spent weeks (not to say months) to figure
this out.
Tks again,
Art.
On Feb 21, 12:11 pm, Chris Spicer chris.spi...@technicana.com wrote:
Hi Art,
Contract codes are always
) = V
MonthCodes(11) = X
MonthCodes(12) = Z
End Sub
Regards,
Chris Spicer
www.Technicana.com
--~--~-~--~~~---~--~~
Visit the blog to download Excel tutorials at
http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros
17 matches
Mail list logo