Styjun

Expected maximum number of unpaired socks

Is "vegetable base" a common term in English?

Is there a simple example that empirical evidence is misleading?

Would Buddhists help non-Buddhists continuing their attachments?

Time complexity of an algorithm: Is it important to state the base of the logarithm?

Testing using real data of the customer

Why sampling a periodic signal doesn't yield a periodic discrete signal?

Possibility of faking someone's public key

Should I split timestamp parts into separate columns?

Does "was machen sie" have the greeting meaning of "what do you do"?

Heat lost in ideal capacitor charging

Why is this integration method not valid?

Can you still travel to America on the ESTA waiver program if you have been to Iran in transit?

Best shape for a necromancer's undead minions for battle?

What is the intuition behind the term Transitive for verbs?

What would prevent living skin from being a good conductor for magic?

Can a UK national work as a paid shop assistant in the USA?

No Iron for your fair-folk maiden? (Part 1)

Removing the last element of a list

Why isn't 'chemically-strengthened glass' made with potassium carbonate? To begin with?

Why A=2 and B=1 in the call signs for Spirit and Opportunity?

How to melt snow without fire or using body heat?

How to respond to an e-mail asking me to suggest a doctoral research topic?

What is the recommended procedure to land a taildragger in a crosswind?

Replace Compile Error: Wrong number of arguments or invalid property assignment

Wrong number of arguments or invalid property assignmentWrong number of arguments or invalid property assignment in VBAWrong number of arguments or invalid property assignment VBA Custom UI CallRange wrong number of arguments or invalid property assignmentTrying to run this program, but getting error “ compile error, wrong number of arguments, or invalid property assignment”VBA code - Compile error: Wrong number of arguments or invalid property assignmentExcel vba: wrong number of argument or invalid property assignment collection addingVBA: Compile error, Wrong number of arguments or invalid property assignment - .findcompile error : wrong number of arguments or invalid property assignmentVBA Excel: wrong number of arguments or invalid property assignment on call function

.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty height:90px;width:728px;box-sizing:border-box;

2

I'm having trouble compiling my code

Dim OriginalText As String
Dim CorrectedText As String

OriginalText = Range("A5").Value

CorrectedText = Replace(OriginalText, "a", "o")

Range("A5").Offset(, 1).Value = CorrectedText

In Cell A5 I have the word Micrasaft and I want to replace with Microsoft.

I get 'Compile error: Wrong number of arguments or invalid property assignment'.

---

I know why, because I called my Sub Replace, didn't know that if you name your sub the same way a formula, it won't compile

excel vba replace

share|improve this question

edited Apr 9 at 7:16

Community♦

11

asked Dec 15 '14 at 16:38

MaxwellMaxwell

409

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  any more code to it? Oh btw. You can achieve the same result with one line of code: Range("A5").Offset(0, 1).Value = Replace(Range("A5"), "a", "o")
  
  – user2140173
  Dec 15 '14 at 16:40
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Same problem, I'm still getting the compile error with your formula, and I eliminated all the declared variables, don't know why I'm getting this error
  
  – Maxwell
  Dec 15 '14 at 16:45
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is this all the code? Where is it located? What is the name of this procedure? Does it take any parameters?
  
  – user2140173
  Dec 15 '14 at 16:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What is .Offset(, 1)?
  
  – Ken White
  Dec 15 '14 at 16:47
  

  
  
  
  


• 
  
  
  

  
  4
  

  
  
  
  
  
  

  
  
  I reckon you've got another function/variable that you called Replace somewhere in your code. Does it work if you change it to use VBA.Replace?
  
  – Rory
  Dec 15 '14 at 16:50
  

  
  
  
  

 | 
show 5 more comments

2

I'm having trouble compiling my code

Dim OriginalText As String
Dim CorrectedText As String

OriginalText = Range("A5").Value

CorrectedText = Replace(OriginalText, "a", "o")

Range("A5").Offset(, 1).Value = CorrectedText

In Cell A5 I have the word Micrasaft and I want to replace with Microsoft.

I get 'Compile error: Wrong number of arguments or invalid property assignment'.

---

I know why, because I called my Sub Replace, didn't know that if you name your sub the same way a formula, it won't compile

excel vba replace

share|improve this question

edited Apr 9 at 7:16

Community♦

11

asked Dec 15 '14 at 16:38

MaxwellMaxwell

409

• 
  
  
  

  
  1
  

  
  
  
  
  
  

  
  
  any more code to it? Oh btw. You can achieve the same result with one line of code: Range("A5").Offset(0, 1).Value = Replace(Range("A5"), "a", "o")
  
  – user2140173
  Dec 15 '14 at 16:40
  
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Same problem, I'm still getting the compile error with your formula, and I eliminated all the declared variables, don't know why I'm getting this error
  
  – Maxwell
  Dec 15 '14 at 16:45
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Is this all the code? Where is it located? What is the name of this procedure? Does it take any parameters?
  
  – user2140173
  Dec 15 '14 at 16:46
  

  
  
  
  


• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  What is .Offset(, 1)?
  
  – Ken White
  Dec 15 '14 at 16:47
  

  
  
  
  


• 
  
  
  

  
  4
  

  
  
  
  
  
  

  
  
  I reckon you've got another function/variable that you called Replace somewhere in your code. Does it work if you change it to use VBA.Replace?
  
  – Rory
  Dec 15 '14 at 16:50
  

  
  
  
  

 | 
show 5 more comments

I'm having trouble compiling my code

Dim OriginalText As String
Dim CorrectedText As String

OriginalText = Range("A5").Value

CorrectedText = Replace(OriginalText, "a", "o")

Range("A5").Offset(, 1).Value = CorrectedText

In Cell A5 I have the word Micrasaft and I want to replace with Microsoft.

I get 'Compile error: Wrong number of arguments or invalid property assignment'.

---

I know why, because I called my Sub Replace, didn't know that if you name your sub the same way a formula, it won't compile

excel vba replace

share|improve this question

edited Apr 9 at 7:16

Community♦

11

asked Dec 15 '14 at 16:38

MaxwellMaxwell

409

Dim OriginalText As String
Dim CorrectedText As String

OriginalText = Range("A5").Value

CorrectedText = Replace(OriginalText, "a", "o")

Range("A5").Offset(, 1).Value = CorrectedText

share|improve this question

edited Apr 9 at 7:16

Community♦

11

asked Dec 15 '14 at 16:38

MaxwellMaxwell

409

share|improve this question

edited Apr 9 at 7:16

Community♦

11

asked Dec 15 '14 at 16:38

MaxwellMaxwell

409

edited Apr 9 at 7:16

Community♦

11

edited Apr 9 at 7:16

Community♦

11

asked Dec 15 '14 at 16:38

MaxwellMaxwell

409

asked Dec 15 '14 at 16:38

MaxwellMaxwell

409

1 Answer
1

active

oldest

votes

0

Try the following way:

Dim OriginalText As String
Dim CorrectedText As String

OriginalText = Range("A5").Value

CorrectedText = VBA.Strings.Replace(OriginalText, "a", "o")

Range("A5").Offset(, 1).Value = CorrectedText

share|improve this answer

edited Mar 23 at 22:55

Ivan Olshansky

6691816

answered Mar 23 at 17:55

MartinBMartinB

1

add a comment | 

Your Answer

StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");

StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);

else
createEditor();

);

function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);



);

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f27488761%2freplace-compile-error-wrong-number-of-arguments-or-invalid-property-assignment%23new-answer', 'question_page');

);

Post as a guest

Name

Email

Required, but never shown

0

Try the following way:

Dim OriginalText As String
Dim CorrectedText As String

OriginalText = Range("A5").Value

CorrectedText = VBA.Strings.Replace(OriginalText, "a", "o")

Range("A5").Offset(, 1).Value = CorrectedText

share|improve this answer

edited Mar 23 at 22:55

Ivan Olshansky

6691816

answered Mar 23 at 17:55

MartinBMartinB

1

add a comment | 

0

Try the following way:

Dim OriginalText As String
Dim CorrectedText As String

OriginalText = Range("A5").Value

CorrectedText = VBA.Strings.Replace(OriginalText, "a", "o")

Range("A5").Offset(, 1).Value = CorrectedText

share|improve this answer

edited Mar 23 at 22:55

Ivan Olshansky

6691816

answered Mar 23 at 17:55

MartinBMartinB

1

add a comment | 

Try the following way:

Dim OriginalText As String
Dim CorrectedText As String

OriginalText = Range("A5").Value

CorrectedText = VBA.Strings.Replace(OriginalText, "a", "o")

Range("A5").Offset(, 1).Value = CorrectedText

share|improve this answer

edited Mar 23 at 22:55

Ivan Olshansky

6691816

answered Mar 23 at 17:55

MartinBMartinB

1

Dim OriginalText As String
Dim CorrectedText As String

OriginalText = Range("A5").Value

CorrectedText = VBA.Strings.Replace(OriginalText, "a", "o")

Range("A5").Offset(, 1).Value = CorrectedText

share|improve this answer

edited Mar 23 at 22:55

Ivan Olshansky

6691816

answered Mar 23 at 17:55

MartinBMartinB

1

edited Mar 23 at 22:55

Ivan Olshansky

6691816

edited Mar 23 at 22:55

Ivan Olshansky

6691816

answered Mar 23 at 17:55

MartinBMartinB

1

answered Mar 23 at 17:55

MartinBMartinB

1