Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Thread: Daily Macro for 31 days in microsoft.public.excel.newusers
Started 1 month, 2 weeks ago by paintbrush
I am having problems with the Macro below. The 6th line is off somehow or 6,7,8,9, being off. Would appreciate any help on the line or any other problem you see with the Macro. Sub BuildingSalvage() 'Assuming row Corresponds to date: 'Sub MyMacro() 'Dim x As Integer 'Determine what day it is x = ...
Site: Discussions in microsoft.public.excel.newusers  Discussions in microsoft.public.excel.newusers - site profile
Forum: microsoft.public.excel.newusers  microsoft.public.excel.newusers - forum profile
Total authors: 3 authors
Total thread posts: 3 posts
Thread activity: no new posts during last week
Domain info for: microsoft.com

Other posts in this thread:

Per Jessen replied 1 month, 2 weeks ago
Hi Range("K") is not a valid cell reference. Not sure if you want to paste in row x, but maybe this: Range("K" & x).select Or better: Range("F32").Copy Range("K" & x).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks_:=False, Transpose:=False Hopes this helps. .......
Size: 2,243 bytes
Customize:  Customize "<b>Reply 1</b>: Daily Macro for 31 days in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"

Don Guillett replied 1 month, 2 weeks ago
instead of > Range("f32").Select > Selection.Copy > Range("K").Select > Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, > SkipBlanks_:=False, Transpose:=False try Cells(x, "K").value = Cells(32, "F").Value -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com...
Size: 2,276 bytes
Customize:  Customize "<b>Reply 2</b>: Daily Macro for 31 days in microsoft.public.excel.newusers :: microsoft.public.excel.newusers :: Discussions in microsoft.public.excel.newusers"

 

Top contributing authors

Name
Posts
paintbrush
1
user's latest post:
Daily Macro for 31 days in...
Published (2009-11-12 16:29:00)
&nbsp; I am having problems with the Macro below. The 6th line is off somehow or 6,7,8,9, being off. Would appreciate any help on the line or any other problem you see with the Macro. Sub BuildingSalvage() 'Assuming row Corresponds to date: 'Sub MyMacro() 'Dim x As Integer 'Determine what day it is x = Format(Date, &quot;d&quot;) Cells(x, &quot;G&quot;).Formula = Date Cells(x,...
Per Jessen
1
user's latest post:
Daily Macro for 31 days in...
Published (2009-11-12 17:56:00)
&nbsp; Hi Range(&quot;K&quot;) is not a valid cell reference. Not sure if you want to paste in row x, but maybe this: Range(&quot;K&quot; &amp; x).select Or better: Range(&quot;F32&quot;).Copy Range(&quot;K&quot; &amp; x).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks_:=False, Transpose:=False Hopes this helps. .... Per On 13 Nov., 01:30, paintbrush &lt;Eastern Ks.com&gt;...
Don Guillett
1
user's latest post:
Daily Macro for 31 days in...
Published (2009-11-13 07:16:00)
&nbsp; instead of &gt; Range(&quot;f32&quot;).Select &gt; Selection.Copy &gt; Range(&quot;K&quot;).Select &gt; Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, &gt; SkipBlanks_:=False, Transpose:=False try Cells(x, &quot;K&quot;).value = Cells(32, &quot;F&quot;).Value -- Don Guillett Microsoft MVP Excel SalesAid Software dguillett1@austin.rr.com...

Related threads on "Discussions in microsoft.public.excel.newusers":

Macro moving with daily date in...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Macro moving with daily date in microsoft.public.excel.newusers
Macro moving with daily date in microsoft.public.excel.newusers
Record Macro and Edit Macro options disabled in...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Record Macro and Edit Macro options disabled in microsoft.public.excel.newusers
Record Macro and Edit Macro options disabled in microsoft.public.excel.newusers
Excel macro copy in microsoft.public.excel.newusers  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Excel macro copy in microsoft.public.excel.newusers
Excel macro copy in microsoft.public.excel.newusers
Require a macro for Excel 2007 in...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Require a macro for Excel 2007 in microsoft.public.excel.newusers
Require a macro for Excel 2007 in microsoft.public.excel.newusers
Macro in excel 2007 in microsoft.public.excel.newusers  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Macro in excel 2007 in microsoft.public.excel.newusers
Macro in excel 2007 in microsoft.public.excel.newusers
Pick up last occupied cell to the left macro in...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Pick up last occupied cell to the left macro in microsoft.public.excel.newusers
Pick up last occupied cell to the left macro in microsoft.public.excel.newusers
Macro Look Up in microsoft.public.excel.newusers  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Macro Look Up in microsoft.public.excel.newusers
Macro Look Up in microsoft.public.excel.newusers
Macro in microsoft.public.excel.newusers  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Macro in microsoft.public.excel.newusers
Macro in microsoft.public.excel.newusers
Using a macro to make a list from Results in...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile Using a macro to make a list from Results in microsoft.public.excel.newusers
Using a macro to make a list from Results in microsoft.public.excel.newusers
How can I activate a macro of auto deletion with respect...  Discussions in microsoft.public.excel.newusers - site profile microsoft.public.excel.newusers - forum profile How can I activate a macro of auto deletion with respect to date in microsoft.public.excel.newusers
How can I activate a macro of auto deletion with respect to date in microsoft.public.excel.newusers

Related threads on other sites:

Questions about the Use of Macros in Daily MS Excel Function  MrExcel Message Board - site profile Excel Questions - forum profile Questions about the Use of Macros in Daily MS Excel Function
Questions about the Use of Macros in Daily MS Excel Function
Study of the Incorporation of Macros in Daily MS Excel Funct  MrExcel Message Board - site profile Other Questions - forum profile Study of the Incorporation of Macros in Daily MS Excel Funct
Study of the Incorporation of Macros in Daily MS Excel Funct
Worstelen met een Excel macro: Excel 2003 interpreteert...  Twitter / Djeph - site profile Djeph - forum profile Worstelen met een Excel macro: Excel 2003 interpreteert een .xml file als zijnde XML, en dat is niet de bedoeling! Snap dat dan! 8:02 AM Jun 26th from web
Worstelen met een Excel macro: Excel 2003 interpreteert een .xml file als zijnde XML, en dat is niet de bedoeling! Snap dat dan! 8:02 AM Jun 26th from web
Macro EXCEL et Macro ACCESS in microsoft.public.fr.excel  Discussions in microsoft.public.fr.excel - site profile microsoft.public.fr.excel - forum profile Macro EXCEL et Macro ACCESS in microsoft.public.fr.excel
Macro EXCEL et Macro ACCESS in microsoft.public.fr.excel
[Excel 2007] print macro Excel 03 --> 07  GoT - Categorieen - site profile OFF - forum profile [Excel 2007] print macro Excel 03 --> 07
[Excel 2007] print macro Excel 03 --> 07
Macro Excel SPG by Sunpropertygroup: Macro needed. See...  freelancejobs - Identi.ca - site profile freelancejobs - forum profile Macro Excel SPG by Sunpropertygroup: Macro needed. See req's. (Budget: $30-250, Jobs: .NET, Visual Basic) http://ping.fm/vhHwB Published about 4 months ago From Ping.fm
Macro Excel SPG by Sunpropertygroup: Macro needed. See req's. (Budget: $30-250, Jobs: .NET, Visual Basic) http://ping.fm/vhHwB Published about 4 months ago From Ping.fm
Macro excel 2000 su excel 2003 in...  Discussions in microsoft.public.it.office.excel - site profile microsoft.public.it.office.excel - forum profile Macro excel 2000 su excel 2003 in microsoft.public.it.office.excel
Macro excel 2000 su excel 2003 in microsoft.public.it.office.excel
EXCEL MACRO - EXCEL VBA HOW TO USE THE FIND AND REPLACE...  Tek-Tips Forums - site profile VBA Visual Basic for Applications (Microsoft) - forum profile EXCEL MACRO - EXCEL VBA HOW TO USE THE FIND AND REPLACE FUNCTION
EXCEL MACRO - EXCEL VBA HOW TO USE THE FIND AND REPLACE FUNCTION
Macro Excel : tableau dynamique - Programmation - OS,...  FORUM Matbe.com - site profile Programmation - forum profile Macro Excel : tableau dynamique - Programmation - OS, Software, Réseaux & Jeux vidéos - FORUM Matbe.com
Macro Excel : tableau dynamique - Programmation - OS, Software, Réseaux & Jeux vidéos - FORUM Matbe.com
Macro excel in microsoft.public.fr.officedev  Discussions in microsoft.public.fr.officedev - site profile microsoft.public.fr.officedev - forum profile Macro excel in microsoft.public.fr.officedev
Macro excel in microsoft.public.fr.officedev
Thread profile page for "Daily Macro for 31 days in microsoft.public.excel.newusers" on http://www.microsoft.com/communities/newsgroups.... This report page is a snippet summary view from a single thread "Daily Macro for 31 days in microsoft.public.excel.newusers", located on the Message Board at http://www.microsoft.com/communities/newsgroups.... This thread profile page shows the thread statistics for: Total Authors, Total Thread Posts, and Thread Activity