Ask for VBA in excel

Help Activities
, ,
1

I have a question.
If column C empty replace with cell B.

How to write VBA?
I choose VBA because data have 10,000 rows , If run by for each row I think If take time too much.

image Input
image Output

2

Hi @fairymemay

Please try this

Sub Macro()

For intCount = 2 To Cells(Rows.Count, 1).End(xlUp).Row
    If Cells(intCount, 3).Value = "" Then Cells(intCount, 3).Value = Cells(intCount, 2).Value
Next intCount

End Sub

Thanks

1 Like
3

@fairymemay,

You can use If formula for this more faster than vba.
plz find attached xaml file and let us know if you’re stuck.

ExcelManipulation.xaml (10.1 KB)

4

@Pankaj.Patil I run your xaml.
After run your xaml column Type not fulfill and data row2 appear as below.

image
File input : data.xlsx (8.2 KB)

5

@fairymemay

Have you tried my code…

Thanks

1 Like
6

@prasath_S It run correctly,

7

@fairymemay,

I again ran it and worked well at me, debug the code(not a big file) and find where code is going wrong.
otherwise use @prasath_S’ code as it’s working for you.

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.