Excel VB-Copy formula down until adjacent cell (left) is blank?
Here is exactly what I am trying to do through VB in Excel:
Weekly data pull fills colums A:G. Row count is always different. I am
modifying the data pull through VB, and I have a VLOOKUP formula in cell H2.
What I want VB to do is copy that formula down column H to the last row (with
data) each week. I guess I want it to be dynamic so that as rows
decrease/increase the formula is only copied down to the final row/record.
I know someone out of this smart group will know how to do this!
Thanks in advance!
in a macro
dim lngLastrow as long
dim rngTarget...Recover Deleted Items Outlook 2003
I can't get the DumpsterAlywaysOn trick to work in
Outlook 2003. Is there a different way of implementing
this in the newer version?
are you certain you did not make the same typo in the registry key that you
made in this post? that key has always worked for me...
"PatricK" <email@example.com> wrote in message
> I can't get the DumpsterAlywaysOn trick to work in
> Outlook 2003. Is there a different way of implementing
> this in the newer version?
> Patric...how do i graph gender & age in in a line graph?
i need to compare age and gender on a line graph but i can not get gender to
be different from just a line how do i change that?
Your question is not too clear. It would be nice to see part of your data.
Are you saying that Excel plots two lines rather than one? If so, delete the
text at the top of the first column you are using for data.
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"lost&needhelp" <firstname.lastname@example.org> wrote in message
news:88472E93-9D32-48B6-8B2C-FAF17EED4ACB@microsoft.com......how do i calculate 10% of a total in an access query
I am working in access 2007 and have a goal amount that i need to calculate a
10% increase.. I cant figure out how to do this!!
Increased Price: ([YourField] * .1) + [YourField]
Build a little - Test a little
"confussed student" wrote:
> I am working in access 2007 and have a goal amount that i need to calculate a
> 10% increase.. I cant figure out how to do this!!
On Mon, 25 Feb 2008 09:13:10 -0800, confussed student wrote:
> I am working in access 2007 and have a goal amount that i need to calculate a
> 10% increase.. I cant figure out how to do...Cannot receive incoming internet eMail
I ahve a win2003 network, with Exchange 2003 running. The DC was down for
about a week, so the email was not working, either. When the DC came back,
email started working, partially.
Now I can send email to outside, but I cannot receive any email at all.
Any idea?? Thanks!
From an outside connection, say your home computer, can you telnet to port
25 of your Exchange Server? Check your Event Viewer on the Exchange Server
for any Errors.
John Oliver, Jr.
MCSE, MCT, CCNA, Exchange MVP
Microsoft Certified Partner
"Rick" <Rick@discussions.microsoft.com> w...Macro is not logging out of Great Plains
I created a macro to login, run checklinks and then log out. I set it up in
the Task Scheduler on my system to run after hours, using a bat file. It
worked for several months, and then in January it didn't finish the macro and
log out. I would come in the morning, and I would still be logged in and the
scheduled task was still running. I had to end task and delete my login in
I have tried recreating the macro, I have tried running it on the server,
and I am still having the same problem. In most cases, the report is
generated - so I know the checklinks are finishing...In excel when inputting dates 10/4/04 (10/april/04) data converts.
In excel when inputting dates 10/4/04 (10/April/2004) excel converts this to
4/10/04 (4/October/2004) Where can I change the input characteristics.
I have changed the date format to English (UK) and this works when I input
the date in the American format mm/dd/yy but I want to input in the dd/mm/yy
I think I'd try chaning my windows regional settings.
In win98, I'd get to it via:
Windows start button|Settings|control Panel|regional settings applet
Change the short date format to dd/mm/yyyy (I like 4 digit dates--you don't have
to use that part--but put it in d...Adding Lines And Boxes, etc. To A Chart ?
Will blame it on my age.
Using Excel 2007 (or, at least trying to) and XP.
When I have a chart page opened up, how do I get it to show the bar on the
bottom (that the real old versions had) that allows one to click on one of
its icons shown to "draw" lines, arrowed lines, boxes, add text with a box,
etc on the chart itself ?
With the chart selected you can use the Insert tab > Illustrations > Shapes.
To add shapes to the chart. Textbox is in the Text group of the Insert tab.
Andy Pope, Microsoft MVP - Excel
http://www.andypo...When form closes it creates a blank record in the table
I have a form that links to a table called 'Suppliers'. Whenever that
form closes it automatically adds a blank record to that table. Is
there a way to prevent that from happening?
Thanks in advance
<MichaelJohnson168@hotmail.com> wrote in message
>I have a form that links to a table called 'Suppliers'. Whenever that
> form closes it automatically adds a blank record to that table. Is
> there a way to prevent that from happening?
If it only happens when you had the form on a new (blank...Money 2007 won't accept Win Live ID
Money 2007 on Vista. It asks for my Windows LIve ID and I've tried three of
them. To all of them it says "Your signin info could not be verified. "Go
On line and then try to sign in." I'm not sure what the "go on line means,
but I closed Money and singed in at several places then tried again and I
get the same error message.
If you have Money 2007 edition, and you cannot sign in with your correct
passport or now called Windows Live address in addition to what is in the
MSKB that addresses this:
1) Turn off your Firewall--this is a 2007 specif...Is Great Plains available in German / Germany?
I thought this was a no-brainer, but the one piece of info I read implies
that GP is not available in Germany:
Would someone have more info?
The following list contains the countries and regions that are available as
localized releases during the Microsoft Dynamics GP installation.
• Andean (new in Microsoft Dynamics GP 10.0)
• Argentina (new in Microsoft Dynamics GP 10.0)
• Chile (new in Microsoft Dynamics GP 10.0)
• Hong Kong
Based ...Printing EXCEL items in WORD
Excel seems to work better for tables than WORD's tables; yet when a table
created in EXCEL is copied and pasted into a WORD document I caannot get the
gridlines to print. Even thouigh in EXCEL the print gridlines instructions
are checked. What should I do?
I've always apply borders--either in Excel or in Word.
select a cell in the table
Format|borders and shading|borders tab
check the All icon.
The gridlines in Word don't print. Word's help says to use borders. (I just
Old Red One wrote:
> Excel seems to work bett...trouble receiving a forwarded email
When someone forwards an email to me not all of the
message is received. It stops about 3/4 of the way down
the page or sometimes the 1st page is there but not page
2. I am using Outlook 2000 SR-1. My computer is Windows
98. Our Server is Windows 2000. No one else is having
...Problem with line Chart
I have the following data:
I would like to create a simple line chart connecting the Value points. Note
that the points correspond to random dates (not evenly spaced). How can I
create a line chart that has time on the x-axis, (say shown in months) with a
line connecting the Value points, which are shown at various locations in
time. Soun...Value creation failed at line 422
Does anyone know the source of this error message and how to fix it?
well, you have to provide more info than that before people here could
provide possible solutions. Info like, what GP application? what window? what
module? what are trying to do on that window? posting? printing? saving? do
you have customizations?
> Does anyone know the source of this error message and how to fix it?
...Calcualting the time between email received date and reply date
My boss wants data as to within how many days a reply was sent to a message.
Is it possible in microsoft outlook to find out after how many days a
message got replied?
Shanks <Shanks@discussions.microsoft.com> wrote:
> My boss wants data as to within how many days a reply was sent to a
> message. Is it possible in microsoft outlook to find out after how
> many days a message got replied?
WIth Outlook 2003, one can observe the received time and compare it to the
"You replied" time shown in the Info Bar.
Is there a...Duplicate emails received (two copies)
I am receiving two copies of each received email. What
could cause this problem?
...Receivables Error Messages
I have the following error messages; can anyone help?
1. An open operation on table 'GL_DP_Distribution_Temp'failed because the
path does not exist.
2. Unhandled database exception;
A save operation on table 'ASI_SQL_Info' has caused an unknown error (48)
Hi Tony, We received #1 error today for the first time. Looking forward to
"Tony F" wrote:
> I have the following error messages; can anyone help?
> 1. An open operation on table 'GL_DP_Distribution_Temp'failed because the
> path does not exist.
> 2. Unhandled ...where can i find the meaning of all icons next to a received mail
"Rolls" <Rolls@discussions.microsoft.com> wrote in message
Please use this BIG WHITE SPACE to write your question.
Have a look here:
Asking a question?
Please tell us the version of the application you are asking about,
your OS, Service Pack level
and the FULL contents of any error message(s)
...How can I retrieve rows from 11 to 20 ( Selete TOP 10 gives first 10)
Using 'Select Top 10' gives me first 10 rows of my table. I need to retrieve
the next 10 records.
I am writing to an excel spreadsheet where I need to write top 10 rows
starting from B2 and next 10 records starting from I2. So how can I split
them? Every time I have to split into 10rows each.
Message posted via AccessMonster.com
Something like this will get the job done. I don't know your table/
SELECT TOP 10 primaryKey FROM myTable
WHERE primaryKey NOT IN (SELECT TOP...Blank Email messages are being received
(1) When the attachments go missing on replied messages,I
hope the client settings were set to include attachments
This setting was set to include the attachments in the
(2) Are there any error messages in the application event
log of exchange?
I've looked for events that might indicate a problem, but
I don't really see anything relevant.
(3) How often does this happen ?
The frequency is very random and not wide spread,
initially, I thought that this was a user error until I
witnessed a couple of users experience this problem first
4) Is there an...Outlook 2003-can't send or receive emails
I have Outlook 2003 with Windows XP Operating system. My
ISP is Earthlink. When I try to send/receive in Outlook,
I get the error message: The operation failed. An object
could not be found. I have gone through my settings, and
all are set as recommended. My test message is received
in my earthlink mailbox, but I cannot retrieve it in
Outlook. I have no trouble with my earthlink mailbox. I
have tried using Detect & Repair - no results. How can I
fix this? Thanks
...Outlook won't break lines in received plain text e-mail
I'm using Outlook 2000 on Windows XP. I moved my .pst
file from another Outlook 2000 on Win98.
Plain text e-mails show no line breaks. I remember on the
previous Outlook I modified a registry key so they would
Do you know how to fix this?
MEDIA RELATIONS OFFICE JET PROPULSION LABORATORY
CALIFORNIA INSTITUTE OF TECHNOLOGY NATIONAL AERONAUTICS
AND SPACE ADMINISTRATION PASADENA, CALIFORNIA 91109.
TELEPHONE (818) 354-5011 http://jpl.convio.net/site/R?i=I-
i=QKroV09E4GFO-3BCLCXxIg.. Guy Webster (818) ...Service Call Line Detail
I'm trying to figure out why the date fields (strtdate, enddate, fulfildat)
are not being populated in the Service Call Line Detail table (SVC00203).
Can anyone give me insight on these fields on why they are all 1/1/1900
dates? We are trying to generate a report based on the dates of the line
items on a Service Call Work Order.
...Need to take out checkboxes from from some items of the listcontrol.. #2
I have a listcontrol in which i want to have checkboxes for only
For that i m trying ,
m_cListCtrl.SetItemState(nRow , LVS_EX_TRACKSELECT,
which is not working.....
PLease help me..
Lotz of thanx in advance,
This link may be useful