Originally posted by TheFaQQer
View Post
- Visitors can check out the Forum FAQ by clicking this link. You have to register before you can post: click the REGISTER link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. View our Forum Privacy Policy.
- Want to receive the latest contracting news and advice straight to your inbox? Sign up to the ContractorUK newsletter here. Every sign up will also be entered into a draw to WIN £100 Amazon vouchers!
Reply to: I have a stupid question
Collapse
You are not logged in or you do not have permission to access this page. This could be due to one of several reasons:
- You are not logged in. If you are already registered, fill in the form below to log in, or follow the "Sign Up" link to register a new account.
- You may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
- If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.
Logging in...
Previously on "I have a stupid question"
Collapse
-
Originally posted by TheFaQQer View PostOops I only meant that BoredBloke is a better VBA programmer than I am. Mainly because I'm not a VBA programmer but can blag a few things here and there
Don't forget to invoice.
Leave a comment:
-
Originally posted by TheFaQQer View PostOops I only meant that BoredBloke is a better VBA programmer than I am. Mainly because I'm not a VBA programmer but can blag a few things here and there
Leave a comment:
-
Originally posted by TheFaQQer View PostIt was a bug in Lisa's conditional formatting
I tried to send her your way, though, but to no avail
Leave a comment:
-
Originally posted by TheFaQQer View PostIt was a bug in Lisa's conditional formatting
I tried to send her your way, though, but to no avail
All sorted now though
Leave a comment:
-
FWIW it seemed to work ok when I tried it
=ValidPostCode(B3)
If you wanted to use it in your VBA rated that having a User defined Function on the worksheet you'd have to loop through the postcodes and throw each one to your function.
for i = 2 to lLR
cells(i,15) = ValidPostCode(cells(i,14))
Next i
Leave a comment:
-
Originally posted by TheFaQQer View PostI've emailed you my spreadsheet
Leave a comment:
-
No worries TF - thanks for posting
Nope still doesn't work. The macro just returns a blank in the field that I would expect to find the formula
Leave a comment:
-
Sorry, missed your email.
Assuming you want a macro to insert a new column in column P (data being in column O), then validate the post codes using the function, try
Code:Sub PostCode() Range("P1").Select Selection.EntireColumn.Insert ActiveCell.FormulaR1C1 = "=IF(ValidPostCode(RC[-1]),""OK"",""Incorrect"")" Range("P1").Select Selection.Copy Range("O1").Select Selection.End(xlDown).Select ActiveCell.Offset(0, 1).Activate Range(Selection, Selection.End(xlUp)).Select ActiveSheet.Paste Application.CutCopyMode = False End Sub
Leave a comment:
-
Morning -sorry to be a bother but I have a teeny problem with this now
The calculation incorporating the expression works perfectly except when I come to incorporate it in a macro - what have I missed???
Sub Postcode()
'
' Postcode Macro
' Macro4
'
'
Columns("P:P").Select
Selection.Insert Shift:=xlToRight, CopyOrigin:=xlFormatFromLeftOrAbove
Range("P2").Select
ActiveCell.FormulaR1C1 = "=IF(ValidPostCode(RC[-1]),""OK"",""Incorrect"")"
Range("P3").Select
End Sub
Leave a comment:
-
Originally posted by mudskipper View PostThat's good. And do you understand it now?
Leave a comment:
-
Originally posted by LisaContractorUmbrella View PostIt works Thanks for all your help guys - really appreciated
Leave a comment:
- Home
- News & Features
- First Timers
- IR35 / S660 / BN66
- Employee Benefit Trusts
- Agency Workers Regulations
- MSC Legislation
- Limited Companies
- Dividends
- Umbrella Company
- VAT / Flat Rate VAT
- Job News & Guides
- Money News & Guides
- Guide to Contracts
- Successful Contracting
- Contracting Overseas
- Contractor Calculators
- MVL
- Contractor Expenses
Advertisers
Contractor Services
CUK News
- Streamline Your Retirement with iSIPP: A Solution for Contractor Pensions Sep 1 09:13
- Making the most of pension lump sums: overview for contractors Sep 1 08:36
- Umbrella company tribunal cases are opening up; are your wages subject to unlawful deductions, too? Aug 31 08:38
- Contractors, relabelling 'labour' as 'services' to appear 'fully contracted out' won't dupe IR35 inspectors Aug 31 08:30
- How often does HMRC check tax returns? Aug 30 08:27
- Work-life balance as an IT contractor: 5 top tips from a tech recruiter Aug 30 08:20
- Autumn Statement 2023 tipped to prioritise mental health, in a boost for UK workplaces Aug 29 08:33
- Final reminder for contractors to respond to the umbrella consultation (closing today) Aug 29 08:09
- Top 5 most in demand cyber security contract roles Aug 25 08:38
- Changes to the right to request flexible working are incoming, but how will contractors be affected? Aug 24 08:25
Leave a comment: