Delete Rows #2
I would like to be able to delete a row with a name in it based on a
cell with that name from another cell in a different worksheet. Any
That worked great, thank you so much.
How do I run the same macro for another name right after this one?
Gary''s Student wrote:
> This macro:
> Sub remover()
> v = Sheets("Sheet1").Range("A1").Value
> For Each r In Sheets("Sheet2").UsedRange
> If r.Value = v Then
> Exit Sub
> End If
> End Sub
&g...Share data across web applications?
I would like to share data across two separate web applications. Is this
possible, other than with Cookies? If so, how might I do it?
I would like to pass non-sensitive information from one web application to
another, on the same web server and running within the same website. I'm
using .NET Framework v2.0 on a Windows 2003 server (IIS 6.0).
Jason Barnett wrote:
> I would like to share data across two separate web applications. Is this
> possible, other than with Cookies? If so, how might I do it?
> I would like to pass non-sensitive information from one...Capital Gains tax in the UK on share sales!
Has anybody got a fix for the following.(day traders must
have come across this problem)or as usual it could be just
If you repurchase a share in the same stock, for capital
gains taxation you have to offset the repurchase against
the shares that were sold. Money will not allow this as
the software knows that you did not poccess the stock
before you purchased them.
1st May Purchase share x
5th May sell share x
7th May repurchase share x
For UK capital gains taxation the shares purchased on the
7th May are offset against the shares sold on the 5th May.
When...DFS shares don't show up but do work!
I noticed that when I do a "NET VIEW \\<any DC>>" our domain DFS
namespaces show up in the list as expected on SOME of the DCs, but on
others all I see is the expected C$, SYSVOL, and NETLOGON but no DFS
As expected, I can do "dir \\<any DC>\<DFS namespace> and that works
on ALL Dc's, *even ones where the dfs name doesn't show up with the
NET VIEW* !
Any ideas?? I've not seen anything like this before... net view has
always been accurate for me.
- the singularity
On May 28, 7:05=A0pm, singularity <anom...outlook delete message outbox problem
I am seeing that this is not an unusual problem. I have tried working "offline". I have tried disconnecting the internet connection to the computer, restarting, delaying message sending, etc. File still will not delete or be moved. I have noticed same "error" message as some others have gotten, mapi spooling? and "message has already begun transmission
what a joke this has been for 2 weeks and I don't even know what archives this has been pulled from. Does anyone have any suggestions?
...prevent users from sending to external doamian
I am running Excange 2003 sp2. I need to prevent users on my server from
sedning emails to a certain external domain on the internet. I have
configured this domain name in connection fltering and recipient filtering
and i also entered the ip address that is associated with the MX record for
this domain. I entered the domain name in format *@domainname.com but my
users can still send emails to this domain.
How come this is not working? I have checked all the boxes on the SMTP
server. Any ehlp with this would be appreciated
skip <firstname.lastname@example.org> wro...Adding to existing code (Clarification of earlier post)
After rereading my earlier post, I find that I wasn't very
clear. I'll try again. My existing code works to give me the sum of all
Weeks Service where the Department Name is equal to the Current Department
Name and I do want to keep that code. In addition to that code though, I
need to add, I'm guessing, an "IF Statement" that will provide me with the
sum of ALL Weeks Service of ALL Department Name IF the Current Department
Name is equal to "Reserves".
Department Name Weeks Service
Millwright ...Alternative for user instance login flag ?
I have SQL Server 2008 Developer Edition only installed on development
PC, have 2008 Standard Edition on the production server. The DBAs have
the production environemnt locked-down.
I created a VS.NET 2008 web application and setup a MDF to use my Dev
Edition DB instance. When I run the app, I try to connect and get
The user instance login flag is not supported on this version of SQL
Server. The connection will be closed.
I understand that only SqlExpress supports this functionality. The
professional DBAs are not going to let me just install another
instance o...Adding VAT fractions
I am using a spreadsheet to calculate VAT. Format is set to two decimal
places, have tried number, currency and accounting methods. Formula is
entered as eg: =A8*7/47 (VAT fraction is 7/47). Answers are displayed
correctly to two decimal places but when adding the column, Excel adds
answer to formula NOT answers displayed in cells. So, although technically
correct, answer is usually a penny or two out. I need it to add what is
displayed. Anyone know how to do this?
When calculating the VAT, round it to 2 dec places, then it should sum
correctly, that is
...Stop Record Deletion
I have a continous form based on a table. The form uses the record selector
function to allow users to easily delete un-wanted data. Some records will
now be uploaded into a differnt system. I have set-up a field to flag which
records have been uploaded. How can I keep the record selector, but stop
rows that have been uploaded (flagged) from being deleted?
"Justin" <Justin@discussions.microsoft.com> wrote in message
> I have a continous form based on a table. The form uses the record
&...Re: Inbox subfolder deleted with its contence, can it be recovered?
I have a user at work who has deleted his inbox subfolder, with all it
content. Believing he had a e-mail highlighted that he wanted t
delete, he deleted by using shift delete, so it perminately deleted th
contents but instead he had the subfolder highlighted, did not look a
the warning message saying you are going to delete "hunter folder an
its contents" *sigh* is there any way this contents be recovered? usin
a thirdparty recovery tool? Thanks in advance
Posted via http://www.mcse.m
----------------...Printing Issues when distributing a form to multiple users
I am distributing a spreadsheet to multiple users. The spreadsheet is
being used as a form for data entry.
The problem i am having is that when it is being printed, the users
are getting varying page layouts where the page breaks have changed,
due the changes to the length of the document growing from the free
text they are entering. The page breaks that excel chooses don't seem
to be spaced well, leading to one or two of the pages being very short
(i.e., leaving a lot of free white space), whereas the other pages are
taking up the entire page.
Is there a particular page layout selection...Help! current RMS users advice on choosing partner
As an actual user of the product what is your opinion on a local partner
versus another partner farther away. I am really torn because I really like
RMS but my local partners in my state (only 2) are not gurus. I am sure they
can handle "setting me up" but there expertise is on other POS systems. I
seemed to understand more of the potential of RMS for my store then they do!
I have only gained that knowledge from my use of Quicksell 2000 and reading
answers on this forum.
My business is a service oriented business. I have suppliers who only sell
to me and not the "m...recording merger with combination cash & shares
I owned Company A stock. Its shares were merged into Company B. The
terms of the merger were that for each share of company A, I received
..1906 shares of Company B plus $16.50.
How should I record this in Money 2003?
This is a multi-part message in MIME format.
Content-Type: text/plain; charset=us-ascii; format=flowed
I tried a "return of capital" for the cash portion but Money 2003 deluxe
voided the transaction after I entered the merger. So I lied and did the
return of capital the day before. The probl...Limited User Account
I am thinking of buying Microsoft Money Plus 2008 to use on a computer
with Windows XP. I read in the user guide that I must install it with
an administrator account, which I would expect. After it is installed,
can I import data from Quicken 2006 and use MS Money Plus
from a limited user account?
The reason I ask is I do all my routine work with a limited user
account and only use the administrator account when absolutely
In microsoft.public.money, Geber wrote:
>I am thinking of buying Microsoft Money Plus 2008 to use on a computer
>with Windows XP. I read in the...Unable to delete public folder in Exch 5.5
I have 2 exch server 5.5 sp3 under same Org and Site container. 1 of the
public folder was created in server b. But server b crashed and left is
server a. Even though in the Outlook we can still see the public folder, but
in the server a, the public folder does not exist coz it was hosted in server
b. I could not delete it and the message says - 'Unable to display the
folders.The contents of this public folder is currently unavailable. Either
the Microsoft Exch Server computer servicing this public folder is down or
the public folder has not been replicated to this site'
Anyone ...can't delete DLL
I wrote a very simple dll and through VC++ debug, I can see it has already
call destroy() when my host program exit; But I find I can't delete it in
folder. it maybe means it is still in use. but I have already free it.
Anyone can give a clue, where's my problem?
I use XP + VC++.
static void a()
static void b()
BOOL WINAPI DllMain(HINSTANCE hInst, DWORD fdwReason, LPVOID lpvReserved)
if (fdwReason == DLL_PROCESS_ATTACH)
if (fdwReason == DLL_PROCESS_DETACH)
...Outlook 2000 Closing msg
I have an Issue with Outlook 20000 running on a win2k
The user closes an email he is reading and it "disappears"
completely. Not even to be found in the deleted folder.
It's probably still there - check the view settings. It sounds like he's
viewing only unread messages.
> I have an Issue with Outlook 20000 running on a win2k
> The user closes an email he is reading and it "disappears"
> completely. Not even to be found in the deleted folder.
> Any Thoughts?...adding a zero in front of number
how do you add a zero in front of other numbers, I am using item numbers and
most start with zero, just shows whole numbers when I enter. example 095421
when I enter shows 95421. help.
When the number must remain numeric data, then format the cell as Custom
"00000" (the number of 0's determines to which length is the entry padded).
When you want the number to be converted to string, then use the formula (in
my example the original number resides in cell A1)
(again, the number of 0's in format string determines the length of padding)
Arvi ...How do I stop Excel from deleting the Window's Clipboard Contents
Note: This is with the Office Clipboard turned OFF!
For example, If I write the following in 5 cells in Excel.
[Hello ][My ][Name ][Is ][Fred ]
Then I Copy (CTRL+C) the Cells: [Is ] and [Fred ] to the
Then I press [Esc] (there are a dozen other ways to do this, but, this is
Now, I go to any cell, anywhere in my workbook, and press Paste (CTRL+V)...
No Data... If I open up Notepad... Paste (CTRL+V).... No Data...
Excel has *decided* for me, that I want to delete the Window's Clipboard
Although I ha...Excel Question: How to Delete All Blank Rows from a worksheet?
Hi, I'm brand new, and that is my question. I just spent 2 hour
laboriously mousing along deleting row by row, every other row thinkin
there's gotta be a better way. (I could've done it of course if the
were adjacent, but they were interspersed with my good data). I'm
little behind the times: agile with keystrokes but less so with mous
[think I was quicker in Lotus DOS! (actually "TWIN")]. But I do play
Message posted from http://www.ExcelForum.com
"DaveThePianoGuy >...Outlook shared contacts/emails
Can someone provide advice?
Computer #1 -- WinXP Home, Outlook SBE 2003
Computer #2 -- WinXP Home, Outlook SBE 2002 (note the year)
My contacts and email accounts are on Computer #1.
I wish for Computer #2 to have access to contacts for email sending, while
storage remains ONLY on Computer #1, but view/response capabilities for
I can find no way to share files and my research has only totally confused
me. I have been an Outlook Express user and have just setup Outlook for its
Computer #2 is an occasional user, so this won't justify much in time ...Getting cells to automatically delete spaces
I have got a very large spreadsheet where the information is presente
Notice the two spaces after the forward slash. There's about 10'00
cells in the column with varying numbers but all in the above format.
I need to get the two spaces deled so that it will appear as:
Is there a way i can get excel to proccess this for me.
Any help will be much appreciated.
Thanks in advance.
Message posted from http://www.ExcelForum.com
Select the required area or a whole sheet, and do a simple Replace (Edit
menu), asking Excel to replace s...HELP: Email body deleted when I receive voting response
Whenever I vote using voting buttons, Email body gets deleted when the
voting response is sent.
So for eg: If I have enabled voting buttons and asked to vote on something
from person xyz, the person xyz votes "accept" or "reject" and the email body
is deleted when I receive the vote response email.
Is there a solution for this? I want the email body to stay when I receive
the voting responses.
Thanks in advance.
I'm doing file maintenance and noticed my inbox size is
15,768 with the total size being 96,206. I reguarly
delete messages with attachments but think the reason for
the large actual size is the attachments are not being
deleted. If this is so, how do you set Outlook 2002 to
automatically delete the attachments? I know previous
versions had a check box to delete attachments but I
cannot find one in this version. If all these attachments
are still saved how do I delete them?