I used "cell.value" instead of just "cell" as the instruction in the IF statement and it worked! Great vid!

Got it. Good vid. Just remember to zoom out, so we can see the format for the named range. I was still using the brackets

Thank you so much! This help to solve my problem

@ExcelVbaIsFun

Жыл бұрын

Fantastic, Manh!!

Thanks!!!!

@ExcelVbaIsFun

10 жыл бұрын

Thanks for the thanks, sir!

THANK YOU

In a For Each loop you should always declare the loop variable. In this case it should be declared as a Range (not as Object, it works, but it is not the right way). If you don't declare it, it will be a Variant (having the wrong default property in this case)

@ExcelVbaIsFun

10 жыл бұрын

Thanks for the tip! Merry Christmas!

@confidential303

4 жыл бұрын

Can you also declare named ranges in VBA.. like Range("a1:a9") as row1.

@ExcelVbaIsFun

4 жыл бұрын

Sure! Dim row1 as range Set row1 = range("a1:a9") row1.select For example.. Thanks Dan

Thank you so much!

@ExcelVbaIsFun

2 жыл бұрын

You're welcome!

I like his voice

i have many named cells in a worksheet. How to loop all the named cells in the worksheet?

Thanks Dan

@ExcelVbaIsFun

10 жыл бұрын

thanks krn14242!

I'm sure it's probably already been commented but all I've seen is people saying what would have worked instead of point out what the error was. I'm not saying to be rude, I just know some of the simplest things I wouldn't expect slip by me; as appears to be the case here. You were merely assigning the variable "blah" the value from LCase(variable) and not assigning the actual cell anything. You could have also used LCase(Left(blah,1)) to better demonstrate the Left(,) function. Please feel free to correct any errors I may have made.

Can you please do a video to show how to change defined named range references using VBA, because I am using a formula to reference the define name range and so the formula need to find the specific named range column. TIA!

awesome

nice to see that we all have gliches when coding but its sticking at it gets the job done

Great tip. cell.Value = LCase(cell) would have worked.

@ExcelVbaIsFun

10 жыл бұрын

thanks Lee!

Dim Blah as range, and prefer Blah.Value not Blah

Why didn't you run through it before making the video? I am none the wiser after watching this.

@ExcelVbaIsFun

9 жыл бұрын

Axischilled83 Billy has a named range called "taxes", where he sets his tax table. To loop through each cell in that range, he types this FOR EACH loop: For each x in range("taxes") 'loops through each cell in that range; do something here. next x Cheers, dan